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.IO_DIAGNOSTICS1 dependencies on RCV_SHIPMENT_HEADERS

Line 8: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := NULL;

4: PROCEDURE req_num_sql(p_ou_id IN NUMBER , p_req_num IN VARCHAR2, p_sql IN OUT NOCOPY INV_DIAG_RCV_PO_COMMON.sqls_list) IS
5: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;
6: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
7: l_line_num po_requisition_lines_all.line_num%TYPE := NULL;
8: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := NULL;
9: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := NULL;
10: l_org_id rcv_shipment_headers.organization_id%TYPE := NULL;
11:
12: BEGIN

Line 9: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := NULL;

5: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;
6: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
7: l_line_num po_requisition_lines_all.line_num%TYPE := NULL;
8: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := NULL;
9: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := NULL;
10: l_org_id rcv_shipment_headers.organization_id%TYPE := NULL;
11:
12: BEGIN
13:

Line 10: l_org_id rcv_shipment_headers.organization_id%TYPE := NULL;

6: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
7: l_line_num po_requisition_lines_all.line_num%TYPE := NULL;
8: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := NULL;
9: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := NULL;
10: l_org_id rcv_shipment_headers.organization_id%TYPE := NULL;
11:
12: BEGIN
13:
14: p_sql(1) := ' select distinct prh.*' ||

Line 140: ' from rcv_shipment_headers rsh , rcv_shipment_lines rsl , po_requisition_headers_all prh , po_requisition_lines_all prl

136:
137:
138:
139: p_sql(9) := ' select distinct rsh.* ' ||
140: ' from rcv_shipment_headers rsh , rcv_shipment_lines rsl , po_requisition_headers_all prh , po_requisition_lines_all prl
141: ' ||
142: ' where rsl.shipment_header_id = rsh.shipment_header_id ' ||
143: ' and prh.requisition_header_id = prl.requisition_header_id ' ||
144: ' and rsl.requisition_line_id = prl.requisition_line_id ' ||

Line 925: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := NULL;

921:
922: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;
923: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
924: l_line_num po_requisition_lines_all.line_num%TYPE := p_line_num;
925: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := NULL;
926: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := NULL;
927: l_org_id rcv_shipment_headers.organization_id%TYPE := NULL;
928:
929: BEGIN

Line 926: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := NULL;

922: l_ou_id po_requisition_headers_all.org_id%TYPE := p_ou_id;
923: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
924: l_line_num po_requisition_lines_all.line_num%TYPE := p_line_num;
925: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := NULL;
926: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := NULL;
927: l_org_id rcv_shipment_headers.organization_id%TYPE := NULL;
928:
929: BEGIN
930:

Line 927: l_org_id rcv_shipment_headers.organization_id%TYPE := NULL;

923: l_req_num po_requisition_headers_all.segment1%TYPE := p_req_num;
924: l_line_num po_requisition_lines_all.line_num%TYPE := p_line_num;
925: l_shipment_num rcv_shipment_headers.shipment_num%TYPE := NULL;
926: l_receipt_num rcv_shipment_headers.receipt_num%TYPE := NULL;
927: l_org_id rcv_shipment_headers.organization_id%TYPE := NULL;
928:
929: BEGIN
930:
931: p_sql(1) := ' select distinct prh.*' ||

Line 1059: ' from rcv_shipment_headers rsh , rcv_shipment_lines rsl , po_requisition_headers_all prh , po_requisition_lines_all prl

1055: ' and pie.table_name = ''RCV_TRANSACTIONS_INTERFACE'' ';
1056:
1057:
1058: p_sql(9) := ' select distinct rsh.* ' ||
1059: ' from rcv_shipment_headers rsh , rcv_shipment_lines rsl , po_requisition_headers_all prh , po_requisition_lines_all prl
1060: ' ||
1061: ' where rsl.shipment_header_id = rsh.shipment_header_id ' ||
1062: ' and prh.requisition_header_id = prl.requisition_header_id ' ||
1063: ' and rsl.requisition_line_id = prl.requisition_line_id ' ||