DBA Data[Home] [Help]

APPS.POS_ASN_CREATE_PVT dependencies on PO_HEADERS_ALL

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

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

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

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