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_CANCEL_ASN dependencies on RCV_SHIPMENT_HEADERS

Line 56: RCV_SHIPMENT_HEADERS rsh

52:
53: CURSOR c_asn_line IS
54: select rsl.shipment_line_id
55: from RCV_SHIPMENT_LINES rsl,
56: RCV_SHIPMENT_HEADERS rsh
57: where rsh.shipment_num = p_shipment_num
58: and rsh.shipment_header_id = rsl.shipment_header_id
59: and rsh.vendor_id = p_vendor_id
60: and rsh.vendor_site_id = p_vendor_site_id;

Line 101: from RCV_SHIPMENT_HEADERS

97:
98: -- Check if shipment already exists in Maintain Shipments view
99: select count(*)
100: into l_count
101: from RCV_SHIPMENT_HEADERS
102: where shipment_num = p_shipment_num
103: and vendor_id = p_vendor_id
104: and vendor_site_id = p_vendor_site_id;
105:

Line 115: from rcv_shipment_headers

111:
112: -- Check if any receipts have been recorded.
113: select count(*)
114: into l_receipt_count
115: from rcv_shipment_headers
116: where shipment_num = p_shipment_num
117: and vendor_id = p_vendor_id
118: and vendor_site_id = p_vendor_site_id
119: and receipt_num is not null;

Line 250: (select shipment_header_id from rcv_shipment_headers

246: select count(*)
247: into l_rsl_line_count
248: from rcv_shipment_lines
249: where shipment_header_id in
250: (select shipment_header_id from rcv_shipment_headers
251: where shipment_num = p_shipment_num
252: and vendor_id = p_vendor_id and vendor_site_id = p_vendor_site_id);
253:
254: if (l_rsl_line_count > 0) then

Line 386: RCV_SHIPMENT_HEADERS rsh

382: /* Get total number of lines */
383: select count(*)
384: into x_total_lines
385: from RCV_SHIPMENT_LINES rsl,
386: RCV_SHIPMENT_HEADERS rsh
387: where rsh.shipment_num = p_shipment_num
388: and rsh.vendor_id = p_vendor_id
389: and rsh.vendor_site_id = p_vendor_site_id
390: and rsh.shipment_header_id = rsl.shipment_header_id;

Line 400: RCV_SHIPMENT_HEADERS rsh

396: /* Get total number of cancelled lines */
397: select count(*)
398: into x_cancelled_lines
399: from RCV_SHIPMENT_LINES rsl,
400: RCV_SHIPMENT_HEADERS rsh
401: where rsh.shipment_num = p_shipment_num
402: and rsh.vendor_id = p_vendor_id
403: and rsh.vendor_site_id = p_vendor_site_id
404: and rsh.shipment_header_id = rsl.shipment_header_id

Line 411: RCV_SHIPMENT_HEADERS rsh

407: /* Get total number of lines pending cancellation */
408: select count(*)
409: into x_pending_cancel
410: from RCV_TRANSACTIONS_INTERFACE rti,
411: RCV_SHIPMENT_HEADERS rsh
412: where rti.transaction_type = 'CANCEL'
413: and rti.shipment_header_id = rsh.shipment_header_id
414: and rsh.shipment_num = p_shipment_num
415: and rsh.vendor_id = p_vendor_id

Line 607: RCV_SHIPMENT_HEADERS rsh

603: /* Get total number of lines */
604: select count(*)
605: into l_total_lines
606: from RCV_SHIPMENT_LINES rsl,
607: RCV_SHIPMENT_HEADERS rsh
608: where rsh.shipment_num = p_shipment_num
609: and rsh.vendor_id = p_vendor_id
610: and rsh.vendor_site_id = p_vendor_site_id
611: and rsh.shipment_header_id = rsl.shipment_header_id;

Line 623: RCV_SHIPMENT_HEADERS rsh

619: /* Get total number of cancelled lines */
620: select count(*)
621: into l_cancelled_lines
622: from RCV_SHIPMENT_LINES rsl,
623: RCV_SHIPMENT_HEADERS rsh
624: where rsh.shipment_num = p_shipment_num
625: and rsh.vendor_id = p_vendor_id
626: and rsh.vendor_site_id = p_vendor_site_id
627: and rsh.shipment_header_id = rsl.shipment_header_id

Line 634: RCV_SHIPMENT_HEADERS rsh

630: /* Get total number of lines pending cancellation */
631: select count(*)
632: into l_pending_cancel
633: from RCV_TRANSACTIONS_INTERFACE rti,
634: RCV_SHIPMENT_HEADERS rsh
635: where rti.transaction_type = 'CANCEL'
636: and rti.shipment_header_id = rsh.shipment_header_id
637: and rsh.shipment_num = p_shipment_num
638: and rsh.vendor_id = p_vendor_id

Line 770: (select shipment_header_id from rcv_shipment_headers

766: select count(*)
767: into l_rsl_line_count
768: from rcv_shipment_lines
769: where shipment_header_id in
770: (select shipment_header_id from rcv_shipment_headers
771: where shipment_num = p_shipment_num
772: and vendor_id = p_vendor_id and vendor_site_id = p_vendor_site_id);
773:
774: if (l_rsl_line_count > 0) then

Line 833: RCV_SHIPMENT_HEADERS rsh

829: /* Get total number of lines */
830: select count(*)
831: into l_total_lines
832: from RCV_SHIPMENT_LINES rsl,
833: RCV_SHIPMENT_HEADERS rsh
834: where rsh.shipment_num = p_shipment_num
835: and rsh.vendor_id = p_vendor_id
836: and rsh.vendor_site_id = p_vendor_site_id
837: and rsh.shipment_header_id = rsl.shipment_header_id;

Line 849: RCV_SHIPMENT_HEADERS rsh

845: /* Get total number of cancelled lines */
846: select count(*)
847: into l_cancelled_lines
848: from RCV_SHIPMENT_LINES rsl,
849: RCV_SHIPMENT_HEADERS rsh
850: where rsh.shipment_num = p_shipment_num
851: and rsh.vendor_id = p_vendor_id
852: and rsh.vendor_site_id = p_vendor_site_id
853: and rsh.shipment_header_id = rsl.shipment_header_id

Line 860: RCV_SHIPMENT_HEADERS rsh

856: /* Get total number of lines pending cancellation */
857: select count(*)
858: into l_pending_cancel
859: from RCV_TRANSACTIONS_INTERFACE rti,
860: RCV_SHIPMENT_HEADERS rsh
861: where rti.transaction_type = 'CANCEL'
862: and rti.shipment_header_id = rsh.shipment_header_id
863: and rsh.shipment_num = p_shipment_num
864: and rsh.vendor_id = p_vendor_id