eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:

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:
945: BEGIN
946: --L1
947: open l_checkUOM_csr;

Line 1052: po_line_locations_all plla,

1048:
1049: from
1050: po_headers_all pha,
1051: po_lines_all pla,
1052: po_line_locations_all plla,
1053: po_vendors pv,
1054: po_vendor_sites_all pvs,
1055: hr_locations_all_tl hrl,
1056: hz_locations hz

Line 1137: po_line_locations_all plla,

1133: from
1134: po_headers_all pha,
1135: po_releases_all pra,
1136: po_lines_all pla,
1137: po_line_locations_all plla,
1138: po_vendors pv,
1139: po_vendor_sites_all pvs,
1140: hr_locations_all_tl hrl,
1141: hz_locations hz

Line 1327: from po_line_locations_all PLL

1323: l_days_early,
1324: l_days_late,
1325: l_due_date,
1326: l_outsourced_assembly
1327: from po_line_locations_all PLL
1328: where line_location_id = l_po_line_location_id;
1329:
1330: if(l_qty_rcv_exception_code = 'REJECT') then
1331: