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_PROCESS_ORGANIZATIONS_GT

Line 378: -- CREATE INDEX GMF_PROCESS_ORGN_GT_N1 ON GMF_PROCESS_ORGANIZATIONS_GT

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
381: -- 14) item_gt colleciton
382: -- 15) prinitng organ_code and item_no in the messages

Line 1554: gmf_process_organizations_gt gpo

1550: AND delete_mark = 0
1551: AND cost_category_id IN
1552: ( SELECT category_id -- cost_category_id Bug#7306720
1553: FROM mtl_item_categories mic,
1554: gmf_process_organizations_gt gpo
1555: WHERE mic.inventory_item_id = p_item_id
1556: AND mic.organization_id = gpo.organization_id
1557: AND (mic.organization_id = p_orgn_id OR p_orgn_id IS NULL)
1558: )

Line 1843: gmf_process_organizations_gt gpo

1839: msi.inventory_item_id,
1840: msi.primary_uom_code
1841: FROM gmf_lot_costed_items lci,
1842: mtl_system_items_b msi,
1843: gmf_process_organizations_gt gpo
1844: WHERE lci.legal_entity_id = l_le_id
1845: AND lci.delete_mark = 0 /* ANTHIYAG Bug#5279681 06-Jun-2006 */
1846: AND gpo.organization_id = msi.organization_id
1847: AND msi.lot_control_code = 2

Line 1860: gmf_process_organizations_gt gpo

1856: i.primary_uom_code
1857: FROM mtl_item_categories mic,
1858: gmf_lot_costed_items g,
1859: mtl_system_items_b i,
1860: gmf_process_organizations_gt gpo
1861: WHERE g.cost_category_id = mic.category_id
1862: AND g.legal_entity_id = l_le_id
1863: AND g.delete_mark = 0
1864: AND i.lot_control_code = 2

Line 8123: AND gpo.organization_id IN (select organization_id from gmf_process_organizations_gt

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
8124: where legal_entity_id = l_le_id)/* Bug 8687115 */
8125: AND glc.final_cost_flag = 0
8126: --AND glc.inventory_item_id = l_item_id /*jboppana*/
8127: AND glc.lot_number = DECODE(l_lot_no, NULL, glc.lot_number, l_lot_no)

Line 8220: gmf_process_organizations_gt gpo

8216: AND t.final_cost_flag = 0 -- Bug 7173679
8217: AND EXISTS (
8218: SELECT 1
8219: FROM gmf_lot_costs glc,
8220: gmf_process_organizations_gt gpo
8221: WHERE glc.organization_id = gpo.organization_id
8222: AND glc.header_id = t.cost_header_id
8223: AND glc.cost_type_id = t.cost_type_id
8224: AND glc.final_cost_flag = 1

Line 8861: FROM gmf_process_organizations_gt

8857:
8858: CURSOR get_process_org IS
8859: SELECT organization_code,
8860: organization_id
8861: FROM gmf_process_organizations_gt
8862: ORDER BY organization_code;
8863:
8864: procedure_name VARCHAR2(100);
8865: BEGIN

Line 8907: gmf_process_organizations_gt gpo

8903: msi.inventory_item_id,
8904: msi.primary_uom_code
8905: FROM gmf_lot_costed_items lci,
8906: mtl_system_items_b msi,
8907: gmf_process_organizations_gt gpo
8908: WHERE lci.legal_entity_id = l_le_id
8909: AND lci.delete_mark = 0 /* ANTHIYAG Bug#5279681 06-Jun-2006 */
8910: AND gpo.organization_id = msi.organization_id
8911: AND msi.lot_control_code = 2

Line 8945: gmf_process_organizations_gt gpo

8941: mtl_default_category_sets mdc,
8942: mtl_category_sets mcs,
8943: gmf_lot_costed_items g,
8944: mtl_system_items_b i,
8945: gmf_process_organizations_gt gpo
8946: WHERE g.cost_category_id = mic.category_id
8947: AND g.legal_entity_id = l_le_id
8948: AND mdc.functional_area_id = 19
8949: AND mdc.category_set_id = mcs.category_set_id

Line 8995: gmf_process_organizations_gt gpo

8991: mtl_default_category_sets mdc,
8992: mtl_category_sets mcs,
8993: gmf_lot_costed_items g,
8994: mtl_system_items_b i,
8995: gmf_process_organizations_gt gpo
8996: WHERE g.cost_category_id = mic.category_id
8997: AND g.legal_entity_id = l_le_id
8998: AND mdc.functional_area_id = 19
8999: AND mdc.category_set_id = mcs.category_set_id

Line 10387: gmf_process_organizations_gt gpo

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,
10391: -- Bug 13038249 Grupo viz changes End

Line 10428: gmf_process_organizations_gt gpo,

10424: FROM mtl_material_transactions mmt,
10425: gme_material_details gme,
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

Line 10485: gmf_process_organizations_gt gpo,

10481: mmt.transaction_id as oc3,
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

Line 10539: gmf_process_organizations_gt gpo,

10535: mmt.transaction_id as oc3,
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

Line 10592: gmf_process_organizations_gt gpo,

10588: mmt.transaction_id as oc3,
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

Line 10698: gmf_process_organizations_gt gpo,

10694: gmf_lc_adj_transactions glat, -- from import process of LCM
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

Line 10762: gmf_process_organizations_gt gpo

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,
10766: -- Bug 13038249 Grupo viz changes End

Line 10803: gmf_process_organizations_gt gpo,

10799: FROM mtl_material_transactions mmt,
10800: gme_material_details gme,
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

Line 10861: gmf_process_organizations_gt gpo,

10857: mmt.transaction_id as oc3,
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

Line 10916: gmf_process_organizations_gt gpo,

10912: mmt.transaction_id as oc3,
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

Line 10970: gmf_process_organizations_gt gpo,

10966: mmt.transaction_id as oc3,
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

Line 11078: gmf_process_organizations_gt gpo,

11074: gmf_lc_adj_transactions glat, -- from import process of LCM
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