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 838: mtl_transaction_lot_numbers mtln,

834: FROM mtl_system_items_b iimb,
835: mtl_material_transactions mmt,
836: gme_batch_step_items gbsi,
837: gme_material_details gmd,
838: mtl_transaction_lot_numbers mtln,
839: mtl_parameters mp,
840: hr_organization_information hoi,
841: gme_transaction_pairs gtp
842: WHERE gbsi.batch_id = p_batch_id

Line 902: mtl_transaction_lot_numbers mtln,

898: )
899: FROM mtl_system_items_b iimb,
900: mtl_material_transactions mmt,
901: gme_material_details gmd,
902: mtl_transaction_lot_numbers mtln,
903: mtl_parameters mp,
904: hr_organization_information hoi
905: WHERE mmt.transaction_source_type_id = 5
906: AND gmd.line_type IN (-1,2)

Line 948: mtl_transaction_lot_numbers mtln,

944: )
945: FROM mtl_system_items_b iimb,
946: mtl_material_transactions mmt,
947: gme_material_details gmd,
948: mtl_transaction_lot_numbers mtln,
949: hr_organization_information hoi
950: WHERE mmt.transaction_source_type_id = 5
951: AND gmd.line_type = 1
952: AND mtln.transaction_quantity <> 0

Line 991: mtl_transaction_lot_numbers mtln,

987: )
988: FROM mtl_system_items_b iimb,
989: mtl_material_transactions mmt,
990: gme_material_details gme,
991: mtl_transaction_lot_numbers mtln,
992: gme_transaction_pairs gtp
993: WHERE mmt.trx_source_line_id = gme.material_detail_id
994: AND gme.batch_id = p_batch_id
995: AND mmt.transaction_quantity <> 0

Line 3027: mtl_transaction_lot_numbers mtln,

3023: CURSOR get_src_qty_uom IS
3024: select mtln.primary_quantity,
3025: lcig.primary_uom_code
3026: from mtl_material_transactions mmt,
3027: mtl_transaction_lot_numbers mtln,
3028: gmf_lot_costed_items_gt lcig
3029: where mmt.transaction_id = transaction_row.transfer_transaction_id
3030: AND mmt.transaction_id = mtln.transaction_id
3031: AND mmt.inventory_item_id = lcig.inventory_item_id

Line 6153: /*UPDATE mtl_transaction_lot_numbers

6149: -- Also, mark the batch as having participated in actual costing - PJS 11Feb04
6150:
6151: IF l_final_run_flag = 1 -- umoogala 05-Dec-2003
6152: THEN
6153: /*UPDATE mtl_transaction_lot_numbers
6154: SET lot_cost_ind = 1,
6155: --request_id = l_request_id,
6156: --program_application_id = l_prog_appl_id,
6157: --program_id = l_program_id,

Line 7437: FROM mtl_transaction_lot_numbers mln,

7433: ELSE /* This is a new lot created from the parent lot */
7434: --check if there is cost from parent lot At this point
7435: SELECT mln.lot_number
7436: INTO l_parent_lot_number
7437: FROM mtl_transaction_lot_numbers mln,
7438: mtl_material_transactions mmt
7439: WHERE mmt.transaction_id = transaction_row.transfer_transaction_id
7440: AND mmt.transaction_id = mln.transaction_id;
7441:

Line 7577: FROM mtl_transaction_lot_numbers mtln, mtl_material_transactions mmt

7573: CURSOR child_lots_cursor IS
7574: SELECT mtln.lot_number,
7575: ABS(mtln.primary_quantity),
7576: mtln.transaction_date
7577: FROM mtl_transaction_lot_numbers mtln, mtl_material_transactions mmt
7578: WHERE mmt.transfer_transaction_id = transaction_row.transfer_transaction_id
7579: AND mmt.transaction_id <> transaction_row.transfer_transaction_id
7580: AND mmt.transaction_id = mtln.transaction_id ;
7581:

Line 7765: FROM mtl_transaction_lot_numbers

7761: SELECT lot_number,
7762: transaction_date
7763: INTO l_lot_number,
7764: l_trans_date
7765: FROM mtl_transaction_lot_numbers
7766: WHERE transaction_id = transaction_row.transfer_transaction_id;
7767:
7768: IF (old_cost_tab.EXISTS(1)) THEN
7769: merge_costs(old_cost_tab,

Line 8678: mtl_transaction_lot_numbers mtln,

8674: NVL(mmt.transaction_cost,0),
8675: mmt.transfer_organization_id
8676: FROM mtl_material_transactions mmt,
8677: gme_material_details gme,
8678: mtl_transaction_lot_numbers mtln,
8679: gme_transaction_pairs gtp,
8680: gmf_process_organizations_gt gpo,
8681: gmf_lot_costed_items_gt lcig
8682: WHERE

Line 8723: mtl_transaction_lot_numbers mtln,

8719: mmt.transfer_transaction_id,
8720: NVL(mmt.transaction_cost,0),
8721: mmt.transfer_organization_id
8722: FROM mtl_material_transactions mmt,
8723: mtl_transaction_lot_numbers mtln,
8724: gmf_process_organizations_gt gpo,
8725: gmf_lot_costed_items_gt lcig
8726: WHERE
8727: gpo.organization_id = mmt.organization_id

Line 8768: mtl_transaction_lot_numbers mtln,

8764: mmt.transfer_transaction_id,
8765: NVL(mmt.transaction_cost,0),
8766: mmt.transfer_organization_id
8767: FROM mtl_material_transactions mmt,
8768: mtl_transaction_lot_numbers mtln,
8769: gmf_process_organizations_gt gpo,
8770: gmf_lot_costed_items_gt lcig
8771: WHERE
8772: gpo.organization_id = mmt.owning_organization_id

Line 8812: mtl_transaction_lot_numbers mtln,

8808: mmt.transfer_transaction_id,
8809: NVL(mmt.transaction_cost,0),
8810: mmt.transfer_organization_id
8811: FROM mtl_material_transactions mmt,
8812: mtl_transaction_lot_numbers mtln,
8813: gmf_process_organizations_gt gpo,
8814: gmf_lot_costed_items_gt lcig
8815: WHERE
8816: gpo.organization_id = mmt.organization_id