DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on PO_REQUISITION_LINES

Line 9210: AND msik.inventory_item_id IN (SELECT item_id FROM po_requisition_lines prl WHERE prl.requisition_header_id = p_reqHeaderID

9206: WHERE
9207: organization_id = p_Organization_Id
9208: AND concatenated_segments like p_concatenated_segments||l_append
9209: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
9210: AND msik.inventory_item_id IN (SELECT item_id FROM po_requisition_lines prl WHERE prl.requisition_header_id = p_reqHeaderID
9211: -- Bug 4346684
9212: -- Add condition to filter the item that dosen't exists in shipments.
9213: AND EXISTS(SELECT 1 FROM rcv_supply rs WHERE rs.req_line_id=prl.requisition_line_id and rs.supply_type_code = 'RECEIVING'))
9214:

Line 9274: AND msik.inventory_item_id IN (SELECT item_id FROM po_requisition_lines prl WHERE prl.requisition_header_id = p_reqHeaderID

9270: AND mcr.cross_reference like g_crossref
9271: AND (mcr.organization_id = msik.organization_id
9272: OR mcr.org_independent_flag = 'Y' )
9273: AND (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
9274: AND msik.inventory_item_id IN (SELECT item_id FROM po_requisition_lines prl WHERE prl.requisition_header_id = p_reqHeaderID
9275: -- Bug 4346684
9276: -- Add condition to filter the item that dosen't exists in shipments.
9277: AND EXISTS(SELECT 1 FROM rcv_supply rs WHERE rs.req_line_id=prl.requisition_line_id and rs.supply_type_code = 'RECEIVING'));
9278: