APPS.GMF_LOT_COSTING_PUB dependencies on HR_ORGANIZATION_INFORMATION

Line 840: hr_organization_information hoi,

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

Line 904: hr_organization_information hoi

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)
907: AND mtln.transaction_quantity <> 0
908: AND mmt.transaction_id = mtln.transaction_id

Line 949: hr_organization_information hoi

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
953: AND mmt.transaction_id = mtln.transaction_id

Line 3601: hr_organization_information hoi1,

3597: mtl_material_transactions mmt,
3598: rcv_shipment_headers r,
3599: rcv_shipment_lines rsl,
3600: po_headers_all poh,
3601: hr_organization_information hoi1,
3602: hr_organization_information hoi2
3603: WHERE
3604: t.source_document_code = 'REQ'
3605: AND t.transaction_id = mmt.rcv_transaction_id

Line 3602: hr_organization_information hoi2

3598: rcv_shipment_headers r,
3599: rcv_shipment_lines rsl,
3600: po_headers_all poh,
3601: hr_organization_information hoi1,
3602: hr_organization_information hoi2
3603: WHERE
3604: t.source_document_code = 'REQ'
3605: AND t.transaction_id = mmt.rcv_transaction_id
3606: AND mmt.transaction_id = transaction_row.transaction_id

Line 3641: hr_organization_information hoi1,

3637: mtl_material_transactions mmt,
3638: rcv_shipment_headers r,
3639: rcv_shipment_lines rsl,
3640: po_headers_all poh,
3641: hr_organization_information hoi1,
3642: hr_organization_information hoi2
3643: WHERE
3644: t.source_document_code = 'INVENTORY'
3645: AND t.transaction_id = mmt.rcv_transaction_id

Line 3642: hr_organization_information hoi2

3638: rcv_shipment_headers r,
3639: rcv_shipment_lines rsl,
3640: po_headers_all poh,
3641: hr_organization_information hoi1,
3642: hr_organization_information hoi2
3643: WHERE
3644: t.source_document_code = 'INVENTORY'
3645: AND t.transaction_id = mmt.rcv_transaction_id
3646: AND mmt.transaction_id = transaction_row.transaction_id

Line 9161: hr_organization_information hoi

9157: hoi.org_information2
9158: INTO l_source_orgn_id,
9159: l_source_le_id
9160: FROM mtl_material_transactions mmt,
9161: hr_organization_information hoi
9162: WHERE mmt.transaction_id = transaction_row.transaction_id
9163: AND hoi.organization_id = mmt.transfer_organization_id
9164: AND hoi.org_information_context = 'Accounting Information';
9165: /* INVCONV sschinch