APPS.POS_EXCELASN_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 932: l_qty_rcv_exception_code po_line_locations_all.qty_rcv_exception_code%type;

928: order by line_number;
929:
930:
931:
932: l_qty_rcv_exception_code po_line_locations_all.qty_rcv_exception_code%type;
933: l_header_id number;
934:
935: --L8: Check for Expected Receipt Date Tolerance per PO Shipment
936: l_receipt_days_exception_code po_line_locations_all.receipt_days_exception_code%type;

Line 936: l_receipt_days_exception_code po_line_locations_all.receipt_days_exception_code%type;

932: l_qty_rcv_exception_code po_line_locations_all.qty_rcv_exception_code%type;
933: l_header_id number;
934:
935: --L8: Check for Expected Receipt Date Tolerance per PO Shipment
936: l_receipt_days_exception_code po_line_locations_all.receipt_days_exception_code%type;
937: l_exp_rec_date pos_exasn_headers.expected_receipt_date%type;
938:
939: l_days_early po_line_locations_all.DAYS_EARLY_RECEIPT_ALLOWED%type;
940: l_days_late po_line_locations_all.DAYS_LATE_RECEIPT_ALLOWED%type;

Line 939: l_days_early po_line_locations_all.DAYS_EARLY_RECEIPT_ALLOWED%type;

935: --L8: Check for Expected Receipt Date Tolerance per PO Shipment
936: l_receipt_days_exception_code po_line_locations_all.receipt_days_exception_code%type;
937: l_exp_rec_date pos_exasn_headers.expected_receipt_date%type;
938:
939: l_days_early po_line_locations_all.DAYS_EARLY_RECEIPT_ALLOWED%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;

Line 940: l_days_late po_line_locations_all.DAYS_LATE_RECEIPT_ALLOWED%type;

936: l_receipt_days_exception_code po_line_locations_all.receipt_days_exception_code%type;
937: l_exp_rec_date pos_exasn_headers.expected_receipt_date%type;
938:
939: l_days_early po_line_locations_all.DAYS_EARLY_RECEIPT_ALLOWED%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;

Line 943: l_outsourced_assembly po_line_locations_all.outsourced_assembly%type;

939: l_days_early po_line_locations_all.DAYS_EARLY_RECEIPT_ALLOWED%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

Line 1069: po_line_locations_all plla,

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,
1072: hr_locations_all_tl hrl,
1073: hz_locations hz

Line 1173: po_line_locations_all plla,

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,
1175: po_vendor_sites_all pvs,
1176: hr_locations_all_tl hrl,
1177: hz_locations hz

Line 1368: from po_line_locations_all PLL

1364: l_days_early,
1365: l_days_late,
1366: l_due_date,
1367: l_outsourced_assembly
1368: from po_line_locations_all PLL
1369: where line_location_id = l_po_line_location_id;
1370:
1371: if(l_qty_rcv_exception_code = 'REJECT') then
1372:

Line 1418: FROM po_line_locations_all

1414: end if;
1415: BEGIN
1416: SELECT po_header_id
1417: INTO l_po_header_id
1418: FROM po_line_locations_all
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