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 HR_ORGANIZATION_INFORMATION

Line 491: , le_id hr_organization_information.org_information2%TYPE

487: (
488: organization_id mtl_parameters.organization_id%TYPE
489: , organization_code mtl_parameters.organization_code%TYPE
490: , process_enabled_flag mtl_parameters.process_enabled_flag%TYPE
491: , le_id hr_organization_information.org_information2%TYPE
492: , ou_id hr_organization_information.org_information3%TYPE
493: );
494: TYPE org_coll_tbl IS TABLE OF org_coll_typ INDEX BY PLS_INTEGER;
495: org_coll_tab org_coll_tbl;

Line 492: , ou_id hr_organization_information.org_information3%TYPE

488: organization_id mtl_parameters.organization_id%TYPE
489: , organization_code mtl_parameters.organization_code%TYPE
490: , process_enabled_flag mtl_parameters.process_enabled_flag%TYPE
491: , le_id hr_organization_information.org_information2%TYPE
492: , ou_id hr_organization_information.org_information3%TYPE
493: );
494: TYPE org_coll_tbl IS TABLE OF org_coll_typ INDEX BY PLS_INTEGER;
495: org_coll_tab org_coll_tbl;
496:

Line 1006: hr_organization_information hoi,

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
1009: AND gbsi.batchstep_id = p_batchstep_id
1010: AND mp.organization_id = mmt.organization_id

Line 1102: hr_organization_information hoi

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)
1105: AND mtln.transaction_quantity(+) <> 0
1106: AND mmt.transaction_id = mtln.transaction_id(+)

Line 1179: hr_organization_information hoi

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
1183: AND mmt.transaction_id = mtln.transaction_id(+)

Line 3638: FROM hr_organization_information

3634:
3635: --Begin Bug 9561690
3636: /* SELECT to_number(org_information3)
3637: INTO l_source_ou
3638: FROM hr_organization_information
3639: WHERE organization_id = p_source_orgn
3640: AND org_information_context = 'Accounting Information';
3641:
3642: SELECT to_number(org_information3)

Line 3644: FROM hr_organization_information

3640: AND org_information_context = 'Accounting Information';
3641:
3642: SELECT to_number(org_information3)
3643: INTO l_target_ou
3644: FROM hr_organization_information
3645: WHERE organization_id = p_target_orgn
3646: AND org_information_context = 'Accounting Information';
3647: --End Bug 9561690
3648:

Line 4309: hr_organization_information hoi1,

4305: mtl_material_transactions mmt,
4306: rcv_shipment_headers r,
4307: rcv_shipment_lines rsl,
4308: po_headers_all poh,
4309: hr_organization_information hoi1,
4310: hr_organization_information hoi2
4311: WHERE
4312: t.source_document_code = 'REQ'
4313: AND t.transaction_id = mmt.rcv_transaction_id

Line 4310: hr_organization_information hoi2

4306: rcv_shipment_headers r,
4307: rcv_shipment_lines rsl,
4308: po_headers_all poh,
4309: hr_organization_information hoi1,
4310: hr_organization_information hoi2
4311: WHERE
4312: t.source_document_code = 'REQ'
4313: AND t.transaction_id = mmt.rcv_transaction_id
4314: AND mmt.transaction_id = transaction_row.transaction_id

Line 4347: hr_organization_information hoi1,

4343: mtl_material_transactions mmt,
4344: rcv_shipment_headers r,
4345: rcv_shipment_lines rsl,
4346: po_headers_all poh,
4347: hr_organization_information hoi1,
4348: hr_organization_information hoi2
4349: WHERE
4350: t.source_document_code = 'INVENTORY'
4351: AND t.transaction_id = mmt.rcv_transaction_id

Line 4348: hr_organization_information hoi2

4344: rcv_shipment_headers r,
4345: rcv_shipment_lines rsl,
4346: po_headers_all poh,
4347: hr_organization_information hoi1,
4348: hr_organization_information hoi2
4349: WHERE
4350: t.source_document_code = 'INVENTORY'
4351: AND t.transaction_id = mmt.rcv_transaction_id
4352: AND mmt.transaction_id = transaction_row.transaction_id

Line 10032: hr_organization_information ou

10028: mp.process_enabled_flag,
10029: ou.org_information2 le_id,
10030: ou.org_information3 ou_id
10031: FROM mtl_parameters mp,
10032: hr_organization_information ou
10033: WHERE ou.org_information_context = 'Accounting Information'
10034: AND mp.organization_id = ou.organization_id
10035: ORDER BY organization_id ;
10036:

Line 11555: hr_organization_information hoi

11551: hoi.org_information2
11552: INTO l_source_orgn_id,
11553: l_source_le_id
11554: FROM mtl_material_transactions mmt,
11555: hr_organization_information hoi
11556: WHERE mmt.transaction_id = transaction_row.transaction_id
11557: AND hoi.organization_id = mmt.transfer_organization_id
11558: AND hoi.org_information_context = 'Accounting Information';
11559: