[Home] [Help]
1102:
1103: /*---------------------------------------------------------
1104: | Completion from a User specified cost type |
1105: | ------------------------------------------ |
1106: | We could go to CICD or Cst_layer_cost_details if the |
1107: | entire org has one average cost, which will be the case |
1108: | for Average costing in a non-project environment. |
1109: | In a project system however, the average cost could be |
1110: | different within the same org. If the user chooses to |
1241: i_prog_appl_id,
1242: i_prog_id,
1243: SYSDATE
1244: FROM
1245: CST_LAYER_COST_DETAILS
1246: WHERE
1247: LAYER_ID = i_layer_id AND
1248: NOT (COST_ELEMENT_ID = 2 AND
1249: LEVEL_TYPE = 1);
1296: i_prog_appl_id,
1297: SYSDATE
1298: from
1299: WIP_REQUIREMENT_OPERATIONS WRO,
1300: CST_LAYER_COST_DETAILS CLCD,
1301: CST_QUANTITY_LAYERS CQL
1302: WHERE
1303: WRO.WIP_ENTITY_ID = i_wip_entity_id AND
1304: WRO.INVENTORY_ITEM_ID = CQL.INVENTORY_ITEM_ID AND
3746: i_prog_appl_id,
3747: i_prog_id,
3748: SYSDATE
3749: FROM
3750: CST_LAYER_COST_DETAILS
3751: WHERE
3752: LAYER_ID = i_layer_id AND
3753: NOT (COST_ELEMENT_ID = 2 AND
3754: LEVEL_TYPE = 1);