APPS.POS_EXCELASN_PVT dependencies on PO_HEADERS_ALL

Line 785: l_doc_num po_headers_all.segment1%type;

781: x_error_tbl in out nocopy POS_EXCELASN_ERROR_TABLE,
782: x_error_pointer in out nocopy number)
783: IS
784:
785: l_doc_num po_headers_all.segment1%type;
786: l_rel_num number;
787: l_revision_num number;
788: l_po_line VARCHAR2(240);
789: l_po_shipment number;

Line 944: l_po_header_id po_headers_all.po_header_id%TYPE;

940: l_days_late po_line_locations_all.DAYS_LATE_RECEIPT_ALLOWED%type;
941: l_due_date date;
942: l_header_line_number number;
943: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type;
944: l_po_header_id po_headers_all.po_header_id%TYPE;
945: l_clm_flag VARCHAR2(1);
946: BEGIN
947: --L1
948: open l_checkUOM_csr;

Line 1067: po_headers_all pha,

1063: plla.ship_to_location_id,
1064: pla.item_description
1065:
1066: from
1067: po_headers_all pha,
1068: po_lines_all pla,
1069: po_line_locations_all plla,
1070: po_vendors pv,
1071: po_vendor_sites_all pvs,

Line 1077: FROM po_headers_archive_all phaa,po_headers_all pha

1073: hz_locations hz
1074: where pha.segment1 = plnt.po_number
1075: and pha.org_id = plnt.org_id
1076: and pha.revision_num = (SELECT pha.revision_num
1077: FROM po_headers_archive_all phaa,po_headers_all pha
1078: WHERE pha.segment1 = plnt.po_number
1079: AND pha.po_header_id =phaa.po_header_id (+)
1080: AND phaa.latest_external_flag(+) ='Y'
1081: AND phaa.revision_num =plnt.po_revision)

Line 1170: po_headers_all pha,

1166: nvl(hrl.location_code, substr(rtrim(hz.address1)||'-'||rtrim(hz.city),1,20)),
1167: plla.ship_to_location_id,
1168: pla.item_description
1169: from
1170: po_headers_all pha,
1171: po_releases_all pra,
1172: po_lines_all pla,
1173: po_line_locations_all plla,
1174: po_vendors pv,

Line 1183: FROM po_headers_archive_all phaa,po_headers_all pha

1179: and pha.org_id = plnt.org_id
1180: and pha.po_header_id = pra.po_header_id
1181: and pra.release_num = plnt.po_release_num
1182: and pra.revision_num = (SELECT pha.revision_num
1183: FROM po_headers_archive_all phaa,po_headers_all pha
1184: WHERE pha.segment1 = plnt.po_number
1185: AND pha.po_header_id =phaa.po_header_id (+)
1186: AND phaa.latest_external_flag(+) ='Y'
1187: AND phaa.revision_num =plnt.po_revision)

Line 1423: FROM PO_HEADERS_ALL POH,

1419: WHERE line_location_id = l_po_line_location_id;
1420:
1421: SELECT NVL(PDSH.CLM_FLAG,'N') CLM_FLAG
1422: INTO l_clm_flag
1423: FROM PO_HEADERS_ALL POH,
1424: PO_DOC_STYLE_HEADERS PDSH
1425: WHERE POH.po_header_id = l_po_header_id AND
1426: NVL(POH.STYLE_ID, 1) = PDSH.STYLE_ID (+) AND
1427: PDSH.STATUS (+) = 'ACTIVE';