DBA Data[Home] [Help]

APPS.RCV_INSPECTION_GRP dependencies on PO_REQUISITION_HEADERS_ALL

Line 94: * PO_REQUISITION_HEADERS_ALL table and fetch the operating_unit_id

90: */
91:
92: /* Bug# 7440432
93: * Modified the below cursor query to also join with
94: * PO_REQUISITION_HEADERS_ALL table and fetch the operating_unit_id
95: * as ORG_ID for requisitions
96: */
97:
98: CURSOR C1 IS

Line 171: PO_REQUISITION_HEADERS_ALL PRHA -- Bug# 7440432

167: MTL_SYSTEM_ITEMS MSI,
168: OE_ORDER_LINES_ALL OEL,
169: OE_ORDER_HEADERS_ALL OEH,
170: MTL_CUSTOMER_ITEMS MCI,
171: PO_REQUISITION_HEADERS_ALL PRHA -- Bug# 7440432
172: WHERE RT.TRANSACTION_ID = RSUP.RCV_TRANSACTION_ID
173: AND RSUP.SUPPLY_TYPE_CODE = 'RECEIVING'
174: AND RSL.SHIPMENT_LINE_ID = RSUP.SHIPMENT_LINE_ID
175: AND RSH.SHIPMENT_HEADER_ID = RSUP.SHIPMENT_HEADER_ID