Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Please Look into the following query and modify it according to your needs. SELECT CLC.* FROM CST_LAYER_COSTS CLC ,CST_COST_DISTRIBUTIONS CCD WHERE 1=1 AND CLC.DISTRIBUTION_ID = CCD.DISTRIBUTION_ID AND CLC.INVENTORY_ITEM_ID = :ITEM_ID AND CLC.COST_REFERENCE = :PO_NO Thanks.