APPS.GMF_LOT_COSTING_PUB dependencies on GMF_LOT_COST_BURDENS

Line 36: --* table (GMF_LOT_COST_BURDENS) has an entry for the whse/item/lot/cost *

32: --* post the cost of a consumption from a lot at the correct cost, based on *
33: --* the transaction date. *
34: --* *
35: --* 10-Oct-2003 PJS More changes, to incorporate burdens on lot costs. If the new burdens *
36: --* table (GMF_LOT_COST_BURDENS) has an entry for the whse/item/lot/cost *
37: --* method code then the burden cost is incorporated into that specific lot's*
38: --* costs. If there is an entry against the whse/item/cost method code then *
39: --* the costs are incorporated into all of the item's lots. A lot that has *
40: --* specific burdens set up will thus have the item level burdens and the *

Line 1287: FROM gmf_lot_cost_burdens

1283: cost_cmpntcls_id,
1284: cost_analysis_code,
1285: burden_factor,
1286: 0
1287: FROM gmf_lot_cost_burdens
1288: WHERE inventory_item_id = p_item_id
1289: AND organization_id = p_orgn_id
1290: AND lot_number = p_lot_number
1291: AND cost_type_id = p_cost_type_id

Line 1301: FROM gmf_lot_cost_burdens

1297: resources,
1298: cost_cmpntcls_id,
1299: cost_analysis_code,
1300: burden_factor, 0
1301: FROM gmf_lot_cost_burdens
1302: WHERE inventory_item_id = p_item_id
1303: AND organization_id = p_orgn_id
1304: AND lot_number IS NULL
1305: AND cost_type_id = p_cost_type_id

Line 1312: FROM gmf_lot_cost_burdens

1308: AND nvl(end_date, p_trans_date) >= p_trans_date
1309: AND (resources, cost_cmpntcls_id, cost_analysis_code)
1310: NOT IN
1311: (SELECT resources, cost_cmpntcls_id, cost_analysis_code
1312: FROM gmf_lot_cost_burdens
1313: WHERE inventory_item_id = p_item_id
1314: AND organization_id = p_orgn_id
1315: AND lot_number = p_lot_number
1316: AND cost_type_id = p_cost_type_id