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 1359: FROM gmf_lot_costed_items_gt g

1355:
1356: CURSOR lot_costed_items
1357: IS
1358: SELECT g.inventory_item_id,g.organization_id
1359: FROM gmf_lot_costed_items_gt g
1360: ORDER BY organization_id,inventory_item_id
1361: ;
1362:
1363:

Line 3028: gmf_lot_costed_items_gt lcig

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
3032: AND mmt.organization_id = lcig.organization_id;

Line 6467: gmf_lot_costed_items_gt gpo

6463: -- Open a cursor that retrieves only the item/lot/sublot specified
6464: OPEN Cur_lc_header FOR
6465: SELECT glc.header_id, glc.rowid
6466: FROM gmf_lot_costs glc,
6467: gmf_lot_costed_items_gt gpo
6468: WHERE glc.organization_id = gpo.organization_id
6469: AND glc.inventory_item_id = gpo.inventory_item_id
6470: AND glc.cost_type_id = l_cost_type_id
6471: AND glc.final_cost_flag = 0

Line 7323: INTO GMF_LOT_COSTED_ITEMS_GT

7319: l_org_tab(cur_rec.organization_id) := cur_rec.organization_code;
7320: END LOOP;
7321:
7322: INSERT
7323: INTO GMF_LOT_COSTED_ITEMS_GT
7324: (
7325: organization_id,
7326: inventory_item_id,
7327: primary_uom_code

Line 8681: gmf_lot_costed_items_gt lcig

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
8683: gpo.organization_id = mmt.organization_id
8684: AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date)
8685: AND mmt.transaction_date <= l_final_run_date

Line 8725: gmf_lot_costed_items_gt lcig

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
8728: AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date)
8729: AND mmt.transaction_date <= l_final_run_date

Line 8770: gmf_lot_costed_items_gt lcig

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
8773: AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date)
8774: AND mmt.transaction_date <= l_final_run_date

Line 8814: gmf_lot_costed_items_gt lcig

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
8817: AND mmt.transaction_date >= NVL(l_trans_start_date, mmt.transaction_date)
8818: AND mmt.transaction_date <= l_final_run_date

Line 8856: gmf_lot_costed_items_gt glci

8852: 0 as transaction_cost,
8853: 0 as transfer_transaction_id
8854: FROM gmf_lot_cost_adjustments glca,
8855: mtl_system_items_b iimb,
8856: gmf_lot_costed_items_gt glci
8857: WHERE glca.applied_ind = 'N'
8858: AND glca.adjustment_date >= NVL(l_trans_start_date, glca.adjustment_date)
8859: AND glca.legal_entity_id = l_le_id
8860: AND glca.cost_type_id = l_cost_type_id