DBA Data[Home] [Help]

APPS.POS_ASN_CREATE_PVT dependencies on PO_RELEASES_ALL

Line 1456: from rcv_transactions_interface rti, po_headers_all poh, po_releases_all por,

1452: /*only for I*/
1453:
1454: select count(*)
1455: into l_rows
1456: from rcv_transactions_interface rti, po_headers_all poh, po_releases_all por,
1457: po_line_locations_all pll
1458: where rti.po_header_id = poh.po_header_id
1459: and rti.po_release_id = por.po_release_id(+)
1460: and rti.po_line_location_id = pll.line_location_id

Line 1469: from rcv_shipment_lines rsl, po_headers_all poh, po_releases_all por,

1465: /*only for S*/
1466:
1467: select count(*)
1468: into l_rows
1469: from rcv_shipment_lines rsl, po_headers_all poh, po_releases_all por,
1470: wms_license_plate_numbers wlpn, po_line_locations_all pll
1471: where rsl.po_header_id = poh.po_header_id
1472: and rsl.po_release_id = por.po_release_id(+)
1473: and rsl.ASN_LPN_ID = wlpn.LPN_ID