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 MTL_TRANSACTION_LOT_NUMBERS

Line 1004: mtl_transaction_lot_numbers mtln,

1000: FROM mtl_system_items_b iimb,
1001: mtl_material_transactions mmt,
1002: gme_batch_step_items gbsi,
1003: gme_material_details gmd,
1004: mtl_transaction_lot_numbers mtln,
1005: mtl_parameters mp,
1006: hr_organization_information hoi,
1007: gme_transaction_pairs gtp
1008: WHERE gbsi.batch_id = p_batch_id

Line 1100: mtl_transaction_lot_numbers mtln,

1096: gmd.dtl_um, gmd.cost_alloc
1097: FROM mtl_system_items_b iimb,
1098: mtl_material_transactions mmt,
1099: gme_material_details gmd,
1100: mtl_transaction_lot_numbers mtln,
1101: mtl_parameters mp,
1102: hr_organization_information hoi
1103: WHERE mmt.transaction_source_type_id = 5
1104: AND gmd.line_type IN (-1,2)

Line 1178: mtl_transaction_lot_numbers mtln,

1174: )
1175: FROM mtl_system_items_b iimb,
1176: mtl_material_transactions mmt,
1177: gme_material_details gmd,
1178: mtl_transaction_lot_numbers mtln,
1179: hr_organization_information hoi
1180: WHERE mmt.transaction_source_type_id = 5
1181: AND gmd.line_type = 1
1182: AND mtln.transaction_quantity(+) <> 0

Line 1223: mtl_transaction_lot_numbers mtln,

1219: )
1220: FROM mtl_system_items_b iimb,
1221: mtl_material_transactions mmt,
1222: gme_material_details gme,
1223: mtl_transaction_lot_numbers mtln,
1224: gme_transaction_pairs gtp
1225: WHERE mmt.trx_source_line_id = gme.material_detail_id
1226: AND mmt.transaction_source_type_id = 5 /* Rajesh B8290451 */
1227: AND mmt.transaction_source_id=gme.batch_id-- added by Francisco 23 Feb 2009

Line 3575: mtl_transaction_lot_numbers mtln,

3571: CURSOR get_src_qty_uom IS
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

Line 7532: /*UPDATE mtl_transaction_lot_numbers

7528: -- Finally, mark the invoking transaction as costed
7529: -- Also, mark the batch as having participated in actual costing - PJS 11Feb04
7530:
7531: IF l_final_run_flag = 1 THEN -- umoogala 05-Dec-2003
7532: /*UPDATE mtl_transaction_lot_numbers
7533: SET lot_cost_ind = 1,
7534: --request_id = l_request_id,
7535: --program_application_id = l_prog_appl_id,
7536: --program_id = l_program_id,

Line 7796: mtl_transaction_lot_numbers mtln -- Bug 13906192

7792: FROM
7793: gmf_lc_adj_transactions glat,
7794: rcv_transactions rt,
7795: mtl_material_transactions mmt, -- Bug 13906192
7796: mtl_transaction_lot_numbers mtln -- Bug 13906192
7797: WHERE
7798: glat.adj_transaction_id = transaction_row.transaction_id
7799: AND glat.rcv_transaction_id = transaction_row.doc_id
7800: AND glat.ship_line_id = transaction_row.line_id

Line 9069: FROM mtl_transaction_lot_numbers mln,

9065: ELSE /* This is a new lot created from the parent lot */
9066: --check if there is cost from parent lot At this point
9067: SELECT mln.lot_number
9068: INTO l_parent_lot_number
9069: FROM mtl_transaction_lot_numbers mln,
9070: mtl_material_transactions mmt
9071: WHERE mmt.transaction_id = transaction_row.transfer_transaction_id
9072: AND mmt.transaction_id = mln.transaction_id;
9073:

Line 9193: FROM mtl_transaction_lot_numbers mtln, mtl_material_transactions mmt

9189: CURSOR child_lots_cursor IS
9190: SELECT mtln.lot_number,
9191: ABS(mtln.primary_quantity),
9192: mtln.transaction_date
9193: FROM mtl_transaction_lot_numbers mtln, mtl_material_transactions mmt
9194: WHERE mmt.transfer_transaction_id = transaction_row.transfer_transaction_id
9195: AND mmt.transaction_id <> transaction_row.transfer_transaction_id
9196: AND mmt.transaction_id = mtln.transaction_id ;
9197:

Line 9363: FROM mtl_transaction_lot_numbers

9359: SELECT lot_number,
9360: transaction_date
9361: INTO l_lot_number,
9362: l_trans_date
9363: FROM mtl_transaction_lot_numbers
9364: WHERE transaction_id = transaction_row.transfer_transaction_id;
9365:
9366: IF (old_cost_tab.EXISTS(1)) THEN
9367: merge_costs(old_cost_tab,

Line 10426: mtl_transaction_lot_numbers mtln,

10422: DECODE(Decode(nvl(gtp.pair_type,0),1,gtp.transaction_id2,NULL), NULL, mmt.transaction_id, (Decode(nvl(gtp.pair_type,0),1,gtp.transaction_id2,NULL)+.5))),mmt.transaction_id) as oc3,
10423: NVL(gbh.routing_id, 0) as routing_id
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

Line 10484: mtl_transaction_lot_numbers mtln,

10480: decode(mmt.transaction_action_id,27,-1,mmt.transaction_source_type_id) as oc2,
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

Line 10538: mtl_transaction_lot_numbers mtln,

10534: decode(mmt.transaction_action_id,27,-1,mmt.transaction_source_type_id) as oc2,
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

Line 10591: mtl_transaction_lot_numbers mtln,

10587: decode(mmt.transaction_action_id,27,-1,mmt.transaction_source_type_id) as oc2,
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

Line 10697: mtl_transaction_lot_numbers mtln, -- Bug 13906192

10693: FROM
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

Line 10801: mtl_transaction_lot_numbers mtln,

10797: DECODE(Decode(nvl(gtp.pair_type,0),1,gtp.transaction_id2,NULL), NULL, mmt.transaction_id, (Decode(nvl(gtp.pair_type,0),1,gtp.transaction_id2,NULL)+.5))),mmt.transaction_id) as oc3,
10798: NVL(gbh.routing_id, 0) as routing_id
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

Line 10860: mtl_transaction_lot_numbers mtln,

10856: decode(mmt.transaction_action_id,27,-1,mmt.transaction_source_type_id) as oc2,
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

Line 10915: mtl_transaction_lot_numbers mtln,

10911: decode(mmt.transaction_action_id,27,-1,mmt.transaction_source_type_id) as oc2,
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

Line 10969: mtl_transaction_lot_numbers mtln,

10965: decode(mmt.transaction_action_id,27,-1,mmt.transaction_source_type_id) as oc2,
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

Line 11077: mtl_transaction_lot_numbers mtln, -- Bug 13906192

11073: FROM
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