DBA Data[Home] [Help]

APPS.PO_R12_CAT_UPG_DEF_PVT dependencies on PO_HEADERS_ALL

Line 1178: FROM PO_HEADERS_ALL POH

1174: num2)
1175: SELECT p_key,
1176: l_subscript_array(i),
1177: POH.agent_id
1178: FROM PO_HEADERS_ALL POH
1179: WHERE POH.po_header_id = x_headers_rec.cpa_reference(i)
1180: AND x_headers_rec.cpa_reference(i) IS NOT NULL
1181: AND x_headers_rec.agent_id(i) IS NULL
1182: --AND x_headers_rec.has_errors(i) = 'N'

Line 1233: FROM PO_HEADERS_ALL POH

1229: FROM (
1230: SELECT agent_id
1231: FROM
1232: (SELECT POH.agent_id
1233: FROM PO_HEADERS_ALL POH
1234: WHERE POH.vendor_id = x_headers_rec.vendor_id(i)
1235: AND POH.vendor_site_id = x_headers_rec.vendor_site_id(i)
1236: AND POH.currency_code = x_headers_rec.currency_code(i)
1237: AND POH.org_id = x_headers_rec.org_id(i)

Line 2425: FROM PO_HEADERS_ALL POH,

2421: POH.vendor_site_id,
2422: POH.ship_to_location_id,
2423: POH.min_release_amount,
2424: POH.po_header_id
2425: FROM PO_HEADERS_ALL POH,
2426: PO_HEADERS_INTERFACE POHI
2427: WHERE POH.po_header_id = POHI.po_header_id
2428: AND POHI.interface_header_id = p_lines_rec.interface_header_id(i)
2429: --AND p_lines_rec.has_errors(i) = 'N'