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 1593: FROM gmf_lot_cost_burdens

1589: cost_cmpntcls_id,
1590: cost_analysis_code,
1591: burden_factor,
1592: 0
1593: FROM gmf_lot_cost_burdens
1594: WHERE inventory_item_id = p_item_id
1595: AND organization_id = p_orgn_id
1596: AND lot_number = p_lot_number
1597: AND cost_type_id = p_cost_type_id

Line 1607: FROM gmf_lot_cost_burdens

1603: resources,
1604: cost_cmpntcls_id,
1605: cost_analysis_code,
1606: burden_factor, 0
1607: FROM gmf_lot_cost_burdens
1608: WHERE inventory_item_id = p_item_id
1609: AND organization_id = p_orgn_id
1610: AND lot_number IS NULL
1611: AND cost_type_id = p_cost_type_id

Line 1618: FROM gmf_lot_cost_burdens

1614: AND nvl(end_date, p_trans_date) >= p_trans_date
1615: AND (resources, cost_cmpntcls_id, cost_analysis_code)
1616: NOT IN
1617: (SELECT resources, cost_cmpntcls_id, cost_analysis_code
1618: FROM gmf_lot_cost_burdens
1619: WHERE inventory_item_id = p_item_id
1620: AND organization_id = p_orgn_id
1621: AND lot_number = p_lot_number
1622: AND cost_type_id = p_cost_type_id

Line 10386: FROM gmf_lot_cost_burdens cb,

10382: oc3,
10383: routing_id,
10384: DECODE(NVL(lcb.item_id,0),0,0,1) AS burden_ind
10385: FROM ( SELECT DISTINCT cb.organization_id, cb.inventory_item_id as item_id
10386: FROM gmf_lot_cost_burdens cb,
10387: gmf_process_organizations_gt gpo
10388: WHERE cb.cost_type_id = l_cost_type_id
10389: AND cb.organization_id = gpo.organization_id
10390: )lcb,

Line 10761: FROM gmf_lot_cost_burdens cb,

10757: oc3,
10758: routing_id,
10759: DECODE(NVL(lcb.item_id,0),0,0,1) AS burden_ind
10760: FROM ( SELECT DISTINCT cb.organization_id, cb.inventory_item_id as item_id
10761: FROM gmf_lot_cost_burdens cb,
10762: gmf_process_organizations_gt gpo
10763: WHERE cb.cost_type_id = l_cost_type_id
10764: AND cb.organization_id = gpo.organization_id
10765: )lcb,