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 115: , hr_organization_information hoi

111: , rcv.shipment_header_id
112: , rcv.shipment_line_id
113: FROM
114: RCV_TRANSACTIONS rcv
115: , hr_organization_information hoi
116: WHERE rcv.organization_id = hoi.organization_id
117: AND hoi.org_information_context = 'Accounting Information'
118: AND rcv.mvt_stat_status = 'NEW'
119: AND (rcv.transaction_type IN ('RECEIVE','RETURN TO VENDOR','MATCH')

Line 146: ,hr_organization_information hoi

142: , rcv.shipment_line_id
143: FROM
144: RCV_TRANSACTIONS rcv
145: ,RCV_SHIPMENT_HEADERS rsh
146: ,hr_organization_information hoi
147: WHERE rcv.shipment_header_id = rsh.shipment_header_id
148: AND rcv.organization_id = hoi.organization_id
149: AND hoi.org_information_context = 'Accounting Information'
150: AND rsh.ship_to_org_id = hoi.organization_id

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

1166: IF rma_crsr%ISOPEN THEN
1167: CLOSE rma_crsr;
1168: END IF;
1169:
1170: --Fix performance bug 4912552, use hr_organization_information to replace
1171: --org_organization_definitions according to proposal from INV
1172: --karthik.gnanamurthy, because inventory organization is already existing
1173: --in rcv_transactions, so it's not required to validate the organization
1174: --again in mtl_parameters or hr_all_organization_units as OOD does

Line 1200: , hr_organization_information hoi /*Bug 8467743*/

1196: , rcv.mvt_stat_status -- 7165989
1197: FROM
1198: RCV_TRANSACTIONS rcv
1199: , oe_order_lines_all oola
1200: , hr_organization_information hoi /*Bug 8467743*/
1201: WHERE rcv.oe_order_line_id = oola.line_id
1202: AND rcv.mvt_stat_status IN ('NEW', 'FORDISP', 'FORARVL') -- 7165989 Changes for RMA triangulation
1203: AND rcv.transaction_type IN ('DELIVER')
1204: AND rcv.source_document_code = 'RMA'

Line 1229: , hr_organization_information hoi

1225: , rcv.subinventory
1226: , rcv.mvt_stat_status -- 7165989
1227: FROM
1228: RCV_TRANSACTIONS rcv
1229: , hr_organization_information hoi
1230: WHERE rcv.organization_id = hoi.organization_id
1231: AND hoi.org_information_context = 'Accounting Information'
1232: AND hoi.org_information2 = to_char(p_movement_transaction.entity_org_id) /* bug 7676431: Added to_char */
1233: AND rcv.mvt_stat_status IN ('NEW', 'FORDISP', 'FORARVL') -- 7165989 Changes for RMA triangulation

Line 1255: , hr_organization_information hoi /*Bug 8467743*/

1251: FROM
1252: RCV_TRANSACTIONS rcv
1253: , RCV_SHIPMENT_HEADERS rsh
1254: , oe_order_lines_all oola
1255: , hr_organization_information hoi /*Bug 8467743*/
1256: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1257: AND rcv.oe_order_line_id = oola.line_id
1258: AND rsh.receipt_num = p_movement_transaction.receipt_num
1259: AND rcv.mvt_stat_status IN ('NEW', 'FORDISP', 'FORARVL') -- 7165989 Changes for RMA triangulation

Line 1286: , hr_organization_information hoi

1282: , rcv.mvt_stat_status -- 7165989
1283: FROM
1284: RCV_TRANSACTIONS rcv
1285: , RCV_SHIPMENT_HEADERS rsh
1286: , hr_organization_information hoi
1287: WHERE rcv.shipment_header_id = rsh.shipment_header_id
1288: AND rcv.organization_id = hoi.organization_id
1289: AND hoi.org_information_context = 'Accounting Information'
1290: AND rsh.ship_to_org_id = hoi.organization_id

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

1689: IF io_arrival_crsr%ISOPEN THEN
1690: CLOSE io_arrival_crsr;
1691: END IF;
1692:
1693: --Fix performance bug 4912552, use hr_organization_information to replace
1694: --org_organization_definitions according to proposal from INV
1695: --karthik.gnanamurthy, because inventory organization is already existing
1696: --in rcv_transactions, so it's not required to validate the organization
1697: --again in mtl_parameters or hr_all_organization_units as OOD does

Line 1720: , hr_organization_information hoi

1716: rcv_transactions rcv
1717: , po_requisition_lines_all prla
1718: , po_requisition_headers_all prha
1719: , oe_order_headers_all orha
1720: , hr_organization_information hoi
1721: WHERE rcv.requisition_line_id = prla.requisition_line_id
1722: AND prla.requisition_header_id = prha.requisition_header_id
1723: AND prha.requisition_header_id = orha.source_document_id
1724: AND orha.order_source_id = 10 --oe_order_sources tbl