eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_LOT_COSTING_PUB dependencies on GMF_LOT_COSTED_ITEMS_GT

Line 376: --CREATE INDEX gmf_lot_costed_items_gt_N1 ON gmf_lot_costed_items_gt

372: -- 9) inv_convert only when different
373: -- 10) inv_tran_cursor, no mtl_system_items in lot cost adjustment query section.
374: -- 11) Removing Le_id join for process_org_gt table
375: -- 12) suggesting following
376: --CREATE INDEX gmf_lot_costed_items_gt_N1 ON gmf_lot_costed_items_gt
377: -- (inventory_item_id,organization_id) ;
378: -- CREATE INDEX GMF_PROCESS_ORGN_GT_N1 ON GMF_PROCESS_ORGANIZATIONS_GT
379: -- (organization_id) ;
380: -- 13) org colleciton

Line 1665: FROM gmf_lot_costed_items_gt g

1661:
1662: CURSOR lot_costed_items
1663: IS
1664: SELECT g.inventory_item_id,g.organization_id
1665: FROM gmf_lot_costed_items_gt g
1666: ORDER BY organization_id,inventory_item_id
1667: ;
1668:
1669:

Line 1826: DELETE FROM GMF_LOT_COSTED_ITEMS_GT ;

1822: IF l_debug_level >= l_debug_level_medium THEN
1823: fnd_file.put_line(fnd_file.log,'Entered Procedure: '||procedure_name);
1824: END IF;
1825:
1826: DELETE FROM GMF_LOT_COSTED_ITEMS_GT ;
1827:
1828: -- Bug 8730374 Modified the insert to load items assigned by category as well
1829:
1830: INSERT

Line 1831: INTO GMF_LOT_COSTED_ITEMS_GT

1827:
1828: -- Bug 8730374 Modified the insert to load items assigned by category as well
1829:
1830: INSERT
1831: INTO GMF_LOT_COSTED_ITEMS_GT
1832: (
1833: organization_id,
1834: inventory_item_id,
1835: primary_uom_code

Line 3576: gmf_lot_costed_items_gt lcig

3572: select NVL(mtln.primary_quantity, mmt.primary_quantity), -- B9131983 used NVL
3573: lcig.primary_uom_code
3574: from mtl_material_transactions mmt,
3575: mtl_transaction_lot_numbers mtln,
3576: gmf_lot_costed_items_gt lcig
3577: where mmt.transaction_id = transaction_row.transfer_transaction_id
3578: AND mmt.transaction_id = mtln.transaction_id
3579: AND mmt.inventory_item_id = lcig.inventory_item_id
3580: AND mmt.organization_id = lcig.organization_id;

Line 8119: gmf_lot_costed_items_gt gpo

8115: -- Open a cursor that retrieves only the item/lot/sublot specified
8116: OPEN Cur_lc_header FOR
8117: SELECT glc.header_id, glc.rowid
8118: FROM gmf_lot_costs glc,
8119: gmf_lot_costed_items_gt gpo
8120: WHERE glc.organization_id = gpo.organization_id
8121: AND glc.inventory_item_id = gpo.inventory_item_id
8122: AND glc.cost_type_id = l_cost_type_id
8123: AND gpo.organization_id IN (select organization_id from gmf_process_organizations_gt

Line 8895: INTO GMF_LOT_COSTED_ITEMS_GT

8891: l_org_tab(cur_rec.organization_id) := cur_rec.organization_code;
8892: END LOOP;
8893:
8894: INSERT
8895: INTO GMF_LOT_COSTED_ITEMS_GT
8896: (
8897: organization_id,
8898: inventory_item_id,
8899: primary_uom_code

Line 8930: INTO GMF_LOT_COSTED_ITEMS_GT

8926: )
8927: );
8928:
8929: INSERT
8930: INTO GMF_LOT_COSTED_ITEMS_GT
8931: (
8932: organization_id,
8933: inventory_item_id,
8934: primary_uom_code

Line 8973: from GMF_LOT_COSTED_ITEMS_GT lcig

8969: )
8970: )
8971: AND not exists ( -- Exclude item/orgs from 1st insert
8972: select 1
8973: from GMF_LOT_COSTED_ITEMS_GT lcig
8974: where lcig.inventory_item_id = i.inventory_item_id
8975: and lcig.organization_id = i.organization_id
8976: );
8977:

Line 8980: INTO GMF_LOT_COSTED_ITEMS_GT

8976: );
8977:
8978: /* Bug 8730374 added this union to load one item if assigned by cost category */
8979: INSERT
8980: INTO GMF_LOT_COSTED_ITEMS_GT
8981: (
8982: organization_id,
8983: inventory_item_id,
8984: primary_uom_code

Line 9012: from GMF_LOT_COSTED_ITEMS_GT lcig

9008: AND g.cost_type_id = l_cost_type_id
9009: AND mic.inventory_item_id = p_item_id
9010: and not exists ( -- Exclude item/orgs from 1st, 2nd inserts
9011: select 1
9012: from GMF_LOT_COSTED_ITEMS_GT lcig
9013: where lcig.inventory_item_id = mic.inventory_item_id
9014: and lcig.organization_id = mic.organization_id
9015: );
9016:

Line 10352: -- One item all lots would still be part of first query. Works as gmf_lot_costed_items_gt would have one item.

10348:
10349: fnd_file.put_line(fnd_File.LOG,'Reading uncosted transactions: '|| to_char(sysdate,'DD-MON-YYYY HH24:MI:SS') );
10350:
10351: -- Perf B14616815 Inv_tran_cursor query is now split into two one for specific lot and another for all lots.
10352: -- One item all lots would still be part of first query. Works as gmf_lot_costed_items_gt would have one item.
10353:
10354: IF l_lot_no IS NULL THEN
10355:
10356: OPEN inv_tran_cursor FOR

Line 10430: gmf_lot_costed_items_gt lcig

10426: mtl_transaction_lot_numbers mtln,
10427: (Select pair_type, transaction_id1, transaction_id2 From gme_transaction_pairs where pair_type = 1) gtp, -- PK Bug 9069363
10428: gmf_process_organizations_gt gpo,
10429: gme_batch_header gbh,
10430: gmf_lot_costed_items_gt lcig
10431: WHERE
10432: gpo.organization_id = mmt.organization_id
10433: -- AND gpo.legal_entity_id = l_le_id -- B 8687115
10434: -- AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date) changed for performance as below B14616815

Line 10486: gmf_lot_costed_items_gt lcig

10482: 0 as routing_id
10483: FROM mtl_material_transactions mmt,
10484: mtl_transaction_lot_numbers mtln,
10485: gmf_process_organizations_gt gpo,
10486: gmf_lot_costed_items_gt lcig
10487: WHERE
10488: gpo.organization_id = mmt.organization_id
10489: -- AND gpo.legal_entity_id = l_le_id -- B 8687115
10490: -- AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date) changed for performance as below B14616815

Line 10540: gmf_lot_costed_items_gt lcig

10536: 0 as routing_id
10537: FROM mtl_material_transactions mmt,
10538: mtl_transaction_lot_numbers mtln,
10539: gmf_process_organizations_gt gpo,
10540: gmf_lot_costed_items_gt lcig
10541: WHERE
10542: gpo.organization_id = mmt.owning_organization_id
10543: -- AND gpo.legal_entity_id = l_le_id -- B 8687115
10544: -- AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date) changed for performance as below B14616815

Line 10593: gmf_lot_costed_items_gt lcig

10589: 0 as routing_id
10590: FROM mtl_material_transactions mmt,
10591: mtl_transaction_lot_numbers mtln,
10592: gmf_process_organizations_gt gpo,
10593: gmf_lot_costed_items_gt lcig
10594: WHERE
10595: gpo.organization_id = mmt.organization_id
10596: -- AND gpo.legal_entity_id = l_le_id -- B 8687115
10597: -- AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date) changed for performance as below B14616815

Line 10644: gmf_lot_costed_items_gt glci

10640: -9 as oc3,
10641: 0 as routing_id
10642: FROM gmf_lot_cost_adjustments glca,
10643: -- mtl_system_items_b iimb,
10644: gmf_lot_costed_items_gt glci
10645: WHERE glca.applied_ind = 'N'
10646: -- AND glca.adjustment_date >= NVL(l_trans_start_date, glca.adjustment_date) changed for performance as below B14616815
10647: AND glca.adjustment_date >= l_trans_start_date
10648: AND glca.legal_entity_id = l_le_id

Line 10699: gmf_lot_costed_items_gt glci

10695: rcv_transactions rt,
10696: mtl_material_transactions mmt, -- Bug 13906192
10697: mtl_transaction_lot_numbers mtln, -- Bug 13906192
10698: gmf_process_organizations_gt gpo,
10699: gmf_lot_costed_items_gt glci
10700: WHERE glat.transaction_date >= l_trans_start_date
10701: -- glat.transaction_date >= NVL(l_trans_start_date,glat.transaction_date) performance changed as above B14616815
10702: -- AND glat.legal_entity_id = l_le_id -- bug 12866252
10703: AND rt.transaction_id = mmt.rcv_transaction_id -- Bug 13906192

Line 10805: gmf_lot_costed_items_gt lcig

10801: mtl_transaction_lot_numbers mtln,
10802: (Select pair_type, transaction_id1, transaction_id2 From gme_transaction_pairs where pair_type = 1) gtp, -- PK Bug 9069363
10803: gmf_process_organizations_gt gpo,
10804: gme_batch_header gbh,
10805: gmf_lot_costed_items_gt lcig
10806: WHERE
10807: gpo.organization_id = mmt.organization_id
10808: -- AND gpo.legal_entity_id = l_le_id -- B 8687115
10809: -- AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date) changed for performance as below B14616815

Line 10862: gmf_lot_costed_items_gt lcig

10858: 0 as routing_id
10859: FROM mtl_material_transactions mmt,
10860: mtl_transaction_lot_numbers mtln,
10861: gmf_process_organizations_gt gpo,
10862: gmf_lot_costed_items_gt lcig
10863: WHERE
10864: gpo.organization_id = mmt.organization_id
10865: -- AND gpo.legal_entity_id = l_le_id -- B 8687115
10866: -- AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date) changed for performance as below B14616815

Line 10917: gmf_lot_costed_items_gt lcig

10913: 0 as routing_id
10914: FROM mtl_material_transactions mmt,
10915: mtl_transaction_lot_numbers mtln,
10916: gmf_process_organizations_gt gpo,
10917: gmf_lot_costed_items_gt lcig
10918: WHERE
10919: gpo.organization_id = mmt.owning_organization_id
10920: -- AND gpo.legal_entity_id = l_le_id -- B 8687115
10921: -- AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date) changed for performance as below B14616815

Line 10971: gmf_lot_costed_items_gt lcig

10967: 0 as routing_id
10968: FROM mtl_material_transactions mmt,
10969: mtl_transaction_lot_numbers mtln,
10970: gmf_process_organizations_gt gpo,
10971: gmf_lot_costed_items_gt lcig
10972: WHERE
10973: gpo.organization_id = mmt.organization_id
10974: -- AND gpo.legal_entity_id = l_le_id -- B 8687115
10975: -- AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date) changed for performance as below B14616815

Line 11023: gmf_lot_costed_items_gt glci

11019: -9 as oc3,
11020: 0 as routing_id
11021: FROM gmf_lot_cost_adjustments glca,
11022: -- mtl_system_items_b iimb,
11023: gmf_lot_costed_items_gt glci
11024: WHERE glca.applied_ind = 'N'
11025: -- AND glca.adjustment_date >= NVL(l_trans_start_date, glca.adjustment_date) changed for performance as below B14616815
11026: AND glca.adjustment_date >= l_trans_start_date
11027: AND glca.legal_entity_id = l_le_id

Line 11079: gmf_lot_costed_items_gt glci

11075: rcv_transactions rt,
11076: mtl_material_transactions mmt, -- Bug 13906192
11077: mtl_transaction_lot_numbers mtln, -- Bug 13906192
11078: gmf_process_organizations_gt gpo,
11079: gmf_lot_costed_items_gt glci
11080: WHERE glat.transaction_date >= l_trans_start_date
11081: -- glat.transaction_date >= NVL(l_trans_start_date,glat.transaction_date) performance changed as above B14616815
11082: -- AND glat.legal_entity_id = l_le_id -- bug 12866252
11083: AND rt.transaction_id = mmt.rcv_transaction_id -- Bug 13906192