APPS.INV_MGD_MVT_PO_MDTR dependencies on HR_ORGANIZATION_INFORMATION

Line 90: --Fix performance bug 4912552, use hr_organization_information to replace

86: IF po_crsr%ISOPEN THEN
87: CLOSE po_crsr;
88: END IF;
89:
90: --Fix performance bug 4912552, use hr_organization_information to replace
91: --org_organization_definitions according to proposal from INV
92: --karthik.gnanamurthy, because inventory organization is already existing
93: --in rcv_transactions, so it's not required to validate the organization
94: --again in mtl_parameters or hr_all_organization_units as OOD does

Line 112: , hr_organization_information hoi

108: , rcv.organization_id
109: , rcv.subinventory
110: FROM
111: RCV_TRANSACTIONS rcv
112: , hr_organization_information hoi
113: WHERE rcv.organization_id = hoi.organization_id
114: AND hoi.org_information_context = 'Accounting Information'
115: AND rcv.mvt_stat_status = 'NEW'
116: AND (rcv.transaction_type IN ('RECEIVE','RETURN TO VENDOR','MATCH')

Line 140: ,hr_organization_information hoi

136: , rcv.subinventory
137: FROM
138: RCV_TRANSACTIONS rcv
139: ,RCV_SHIPMENT_HEADERS rsh
140: ,hr_organization_information hoi
141: WHERE rcv.shipment_header_id = rsh.shipment_header_id
142: AND rcv.organization_id = hoi.organization_id
143: AND hoi.org_information_context = 'Accounting Information'
144: AND rsh.ship_to_org_id = hoi.organization_id

Line 1091: --Fix performance bug 4912552, use hr_organization_information to replace

1087: IF rma_crsr%ISOPEN THEN
1088: CLOSE rma_crsr;
1089: END IF;
1090:
1091: --Fix performance bug 4912552, use hr_organization_information to replace
1092: --org_organization_definitions according to proposal from INV
1093: --karthik.gnanamurthy, because inventory organization is already existing
1094: --in rcv_transactions, so it's not required to validate the organization
1095: --again in mtl_parameters or hr_all_organization_units as OOD does

Line 1145: , hr_organization_information hoi

1141: , rcv.subinventory
1142: , rcv.mvt_stat_status -- 7165989
1143: FROM
1144: RCV_TRANSACTIONS rcv
1145: , hr_organization_information hoi
1146: WHERE rcv.organization_id = hoi.organization_id
1147: AND hoi.org_information_context = 'Accounting Information'
1148: AND hoi.org_information2 = to_char(p_movement_transaction.entity_org_id) /* bug 7676431: Added to_char */
1149: AND rcv.mvt_stat_status IN ('NEW', 'FORDISP', 'FORARVL') -- 7165989 Changes for RMA triangulation

Line 1197: , hr_organization_information hoi

1193: , rcv.mvt_stat_status -- 7165989
1194: FROM
1195: RCV_TRANSACTIONS rcv
1196: , RCV_SHIPMENT_HEADERS rsh
1197: , hr_organization_information hoi
1198: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1199: AND rcv.organization_id = hoi.organization_id
1200: AND hoi.org_information_context = 'Accounting Information'
1201: AND rsh.ship_to_org_id = hoi.organization_id

Line 1538: --Fix performance bug 4912552, use hr_organization_information to replace

1534: IF io_arrival_crsr%ISOPEN THEN
1535: CLOSE io_arrival_crsr;
1536: END IF;
1537:
1538: --Fix performance bug 4912552, use hr_organization_information to replace
1539: --org_organization_definitions according to proposal from INV
1540: --karthik.gnanamurthy, because inventory organization is already existing
1541: --in rcv_transactions, so it's not required to validate the organization
1542: --again in mtl_parameters or hr_all_organization_units as OOD does

Line 1561: , hr_organization_information hoi

1557: rcv_transactions rcv
1558: , po_requisition_lines_all prla
1559: , po_requisition_headers_all prha
1560: , oe_order_headers_all orha
1561: , hr_organization_information hoi
1562: WHERE rcv.requisition_line_id = prla.requisition_line_id
1563: AND prla.requisition_header_id = prha.requisition_header_id
1564: AND prha.requisition_header_id = orha.source_document_id
1565: AND orha.order_source_id = 10 --oe_order_sources tbl