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.PO_CREATE_SR_ASL dependencies on PO_LINES_ALL

Line 37: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE;

33: l_sr_organization_id number;
34: l_process_po varchar2(1);
35: x_progress varchar2(300);
36: l_document_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
37: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE;
38: l_po_line_num PO_LINES_ALL.LINE_NUM%TYPE;
39: l_new_line_num PO_LINES_ALL.LINE_NUM%TYPE;
40: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
41: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%TYPE;

Line 38: l_po_line_num PO_LINES_ALL.LINE_NUM%TYPE;

34: l_process_po varchar2(1);
35: x_progress varchar2(300);
36: l_document_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
37: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE;
38: l_po_line_num PO_LINES_ALL.LINE_NUM%TYPE;
39: l_new_line_num PO_LINES_ALL.LINE_NUM%TYPE;
40: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
41: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%TYPE;
42: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;

Line 39: l_new_line_num PO_LINES_ALL.LINE_NUM%TYPE;

35: x_progress varchar2(300);
36: l_document_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
37: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE;
38: l_po_line_num PO_LINES_ALL.LINE_NUM%TYPE;
39: l_new_line_num PO_LINES_ALL.LINE_NUM%TYPE;
40: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
41: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%TYPE;
42: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;
43: l_approved_flag varchar2(20);

Line 42: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;

38: l_po_line_num PO_LINES_ALL.LINE_NUM%TYPE;
39: l_new_line_num PO_LINES_ALL.LINE_NUM%TYPE;
40: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
41: l_vendor_site_id PO_HEADERS_ALL.VENDOR_SITE_ID%TYPE;
42: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;
43: l_approved_flag varchar2(20);
44: l_start_date DATE;
45: l_end_date DATE;
46: l_interface_header_id NUMBER;

Line 155: FROM po_lines_all pl,

151: pl.item_id,
152: ph.vendor_id,
153: ph.vendor_site_id,
154: DECODE(ph.approved_flag,'Y','APPROVED',null)
155: FROM po_lines_all pl,
156: po_headers_all ph
157: WHERE pl.po_header_id = ph.po_header_id
158: AND ph.po_header_id = x_header_id
159: AND pl.item_id is not null

Line 180: FROM po_lines_all pl,

176: pl.item_id,
177: ph.vendor_id,
178: ph.vendor_site_id,
179: DECODE(ph.approved_flag,'Y','APPROVED',null)
180: FROM po_lines_all pl,
181: po_headers_all ph
182: WHERE pl.po_header_id = ph.po_header_id
183: AND ph.po_header_id = x_header_id
184: AND pl.item_id is not null

Line 247: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;

243: l_create_asl varchar2(2);
244: x_progress varchar2(300);
245: l_interface_header_id NUMBER;
246: l_interface_line_id NUMBER;
247: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;
248: l_category_id NUMBER;
249: l_document_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
250: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;
251: l_document_type varchar2(25);

Line 250: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;

246: l_interface_line_id NUMBER;
247: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;
248: l_category_id NUMBER;
249: l_document_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
250: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;
251: l_document_type varchar2(25);
252: l_rel_gen_method varchar2(20);
253: l_sr_organization_id NUMBER;
254: l_header_processable_flag varchar2(1);

Line 370: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;

366: l_create_sr VARCHAR2(2);
367: x_progress VARCHAR2(300);
368: l_interface_header_id NUMBER;
369: l_interface_line_id NUMBER;
370: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;
371: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
372: l_document_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
373: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;
374: l_document_type VARCHAR2(25);

Line 373: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;

369: l_interface_line_id NUMBER;
370: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;
371: l_vendor_id PO_HEADERS_ALL.VENDOR_ID%TYPE;
372: l_document_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE;
373: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;
374: l_document_type VARCHAR2(25);
375: l_approved_flag VARCHAR2(20);
376: l_rule_name VARCHAR2(50);
377: l_rule_prefix VARCHAR2(20);

Line 570: l_previous_line_num PO_LINES_ALL.line_num%type;

566: p_assignment_set_id IN MRP_ASSIGNMENT_SETS.assignment_set_id%type) IS
567:
568: /* Local variables declared for Concurrent Program specific requirements */
569: l_archive_on_approve PO_DOCUMENT_TYPES_ALL.archive_external_revision_code%type;
570: l_previous_line_num PO_LINES_ALL.line_num%type;
571: l_orgid PO_HEADERS_ALL.org_id%type;
572:
573: /* Local variables Package specific information... Required for logging */
574: l_procedure_name varchar2(50):='create_autosource_rules : ';

Line 582: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;

578: l_interface_header_id NUMBER;
579: l_interface_line_id NUMBER;
580: l_document_type_code VARCHAR2(10):= 'PA';
581: l_document_subtype VARCHAR2(10):= 'BLANKET';
582: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;
583: l_category_id NUMBER;
584: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;
585: l_approved_flag VARCHAR2(20);
586: l_rule_prefix VARCHAR2(20);

Line 584: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;

580: l_document_type_code VARCHAR2(10):= 'PA';
581: l_document_subtype VARCHAR2(10):= 'BLANKET';
582: l_item_id PO_LINES_ALL.ITEM_ID%TYPE;
583: l_category_id NUMBER;
584: l_po_line_id PO_LINES_ALL.PO_LINE_ID%TYPE := null;
585: l_approved_flag VARCHAR2(20);
586: l_rule_prefix VARCHAR2(20);
587: l_start_date DATE;
588: l_end_date DATE;

Line 620: FROM po_lines_all pl,

616: ph.start_date,
617: ph.end_date,
618: pl.item_id,
619: DECODE(ph.approved_flag,'Y','APPROVED',null)
620: FROM po_lines_all pl,
621: po_headers_all ph
622: WHERE pl.po_header_id = ph.po_header_id
623: AND ph.po_header_id = p_document_id
624: AND pl.item_id is not null

Line 646: FROM po_lines_all pl,

642: ph.start_date,
643: ph.end_date,
644: pl.item_id,
645: DECODE(ph.approved_flag,'Y','APPROVED',null)
646: FROM po_lines_all pl,
647: po_headers_all ph
648: WHERE pl.po_header_id = ph.po_header_id
649: AND ph.po_header_id = p_document_id
650: AND pl.item_id is not null