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.

[Home] [Help]

APPS.RCV_ROI_TRANSACTION dependencies on RCV_SHIPMENT_LINES

Line 2963: l_shipment_line_status_code rcv_shipment_lines.shipment_line_status_code%TYPE;

2959: x_allow_rate_override VARCHAR2(1);
2960: /* Bug# 1548597 */
2961: x_secondary_available_qty NUMBER := 0;
2962: l_receipt_source_code rcv_shipment_headers.receipt_source_code%TYPE;
2963: l_shipment_line_status_code rcv_shipment_lines.shipment_line_status_code%TYPE;
2964: l_asn_line_flag rcv_shipment_lines.asn_line_flag%TYPE;
2965: l_asn_exists_code rcv_parameters.receipt_asn_exists_code%TYPE;
2966: l_does_asn_exist VARCHAR2(1) := 'N';
2967: l_asn_count NUMBER := 0;

Line 2964: l_asn_line_flag rcv_shipment_lines.asn_line_flag%TYPE;

2960: /* Bug# 1548597 */
2961: x_secondary_available_qty NUMBER := 0;
2962: l_receipt_source_code rcv_shipment_headers.receipt_source_code%TYPE;
2963: l_shipment_line_status_code rcv_shipment_lines.shipment_line_status_code%TYPE;
2964: l_asn_line_flag rcv_shipment_lines.asn_line_flag%TYPE;
2965: l_asn_exists_code rcv_parameters.receipt_asn_exists_code%TYPE;
2966: l_does_asn_exist VARCHAR2(1) := 'N';
2967: l_asn_count NUMBER := 0;
2968: l_dist_count number; /* Bug#3746516 */

Line 3897: rcv_shipment_lines rsl

3893: FROM po_line_locations pll,
3894: po_lines pl,
3895: po_headers ph,
3896: rcv_shipment_headers rsh,
3897: rcv_shipment_lines rsl
3898: WHERE rsh.shipment_header_id = temp_cascaded_table(current_n).shipment_header_id
3899: AND rsl.shipment_line_id = temp_cascaded_table(current_n).shipment_line_id
3900: AND rsl.po_header_id = temp_cascaded_table(current_n).po_header_id
3901: AND rsl.po_line_id = temp_cascaded_table(current_n).po_line_id

Line 4202: rcv_shipment_lines rsl

4198:
4199: SELECT COUNT(*)
4200: INTO l_asn_count
4201: FROM rcv_shipment_headers rsh,
4202: rcv_shipment_lines rsl
4203: WHERE rsh.shipment_header_id = rsl.shipment_header_id
4204: AND NVL(rsh.asn_type, 'STD') IN ('ASN','ASBN') --4287932
4205: AND NVL(rsl.shipment_line_status_code, 'EXPECTED') NOT IN('CANCELLED', 'FULLY RECEIVED')
4206: AND rsl.po_line_location_id = x_shipmentdistributionrec.line_location_id;

Line 9423: rcv_shipment_lines rsl,

9419: rt.quantity qty,
9420: 0 interface_available_qty
9421: FROM rcv_supply rsup,
9422: rcv_transactions rt,
9423: rcv_shipment_lines rsl,
9424: po_headers poh,
9425: po_lines pol
9426: WHERE rt.transaction_id = v_parent_trx_id
9427: AND rsup.to_organization_id = NVL(v_to_organization_id, rsup.to_organization_id)

Line 9530: rcv_shipment_lines rsl,

9526: rt.quantity qty,
9527: 0 interface_available_qty
9528: FROM rcv_supply rsup,
9529: rcv_transactions rt,
9530: rcv_shipment_lines rsl,
9531: po_headers poh,
9532: po_lines pol,
9533: po_distributions pod
9534: WHERE rt.transaction_id = v_parent_trx_id

Line 9645: rcv_shipment_lines rsl,

9641: rt.quantity qty,
9642: 0 interface_available_qty
9643: FROM rcv_supply rsup,
9644: rcv_transactions rt,
9645: rcv_shipment_lines rsl,
9646: po_headers poh,
9647: po_lines pol,
9648: po_distributions pod
9649: WHERE rt.transaction_id = v_parent_trx_id

Line 9753: rcv_shipment_lines rsl,

9749: rt.quantity qty,
9750: 0 interface_available_qty
9751: FROM rcv_supply rsup,
9752: rcv_transactions rt,
9753: rcv_shipment_lines rsl,
9754: po_headers poh,
9755: po_lines pol,
9756: po_distributions pod
9757: WHERE rt.transaction_id = v_parent_trx_id

Line 11490: rcv_shipment_lines rsl,

11486: rt.customer_id,
11487: rt.customer_site_id,
11488: rt.source_document_code
11489: FROM rcv_transactions rt,
11490: rcv_shipment_lines rsl,
11491: rcv_supply rsup
11492: WHERE rt.transaction_id = v_parent_trx_id
11493: AND rt.transaction_id = rsup.rcv_transaction_id
11494: AND rsup.supply_type_code = 'RECEIVING'

Line 12071: rcv_shipment_lines rsl,

12067: rt.wip_line_id,
12068: rt.bom_resource_id,
12069: rsl.ussgl_transaction_code
12070: FROM rcv_transactions rt,
12071: rcv_shipment_lines rsl,
12072: po_headers poh,
12073: po_lines pol
12074: WHERE rt.transaction_id = v_parent_trx_id
12075: AND rt.organization_id = NVL(v_to_organization_id, rt.organization_id)

Line 12854: rcv_shipment_lines rsl

12850: INTO l_transaction_uom,
12851: l_item_id,
12852: l_primary_uom
12853: FROM rcv_transactions rt,
12854: rcv_shipment_lines rsl
12855: WHERE rsl.shipment_line_id = rt.shipment_line_id
12856: AND rt.transaction_id = x_po_correctrec.rcv_transaction_id;
12857:
12858: SELECT NVL(SUM(interface_transaction_qty),0)

Line 13200: rcv_shipment_lines rsl,

13196: rt.po_distribution_id,
13197: rt.destination_type_code,
13198: rsl.ussgl_transaction_code
13199: FROM rcv_transactions rt,
13200: rcv_shipment_lines rsl,
13201: po_headers poh,
13202: po_lines pol
13203: WHERE rt.transaction_id = v_parent_trx_id
13204: AND rt.organization_id = NVL(v_to_organization_id, rt.organization_id)

Line 14183: rcv_shipment_lines rsl

14179: rt.customer_site_id,
14180: rt.source_document_code,
14181: rt.job_id
14182: FROM rcv_transactions rt,
14183: rcv_shipment_lines rsl
14184: WHERE rt.transaction_id = v_parent_trx_id
14185: AND ( rt.transaction_type IN('RECEIVE', 'TRANSFER', 'ACCEPT', 'REJECT', 'MATCH')
14186: OR ( rt.transaction_type IN('RETURN TO VENDOR', 'RETURN TO CUSTOMER')
14187: AND NOT EXISTS(SELECT 'rtv to processed matched unordered receipt'

Line 14730: FROM rcv_shipment_lines

14726: SELECT quantity_shipped,
14727: secondary_quantity_shipped
14728: INTO l_quantity_shipped,
14729: l_secondary_quantity_shipped
14730: FROM rcv_shipment_lines
14731: WHERE shipment_header_id = x_cascaded_table(n).shipment_header_id
14732: AND shipment_line_id = x_cascaded_table(n).shipment_line_id;
14733: EXCEPTION
14734: WHEN OTHERS THEN

Line 15746: l_rsl_uom rcv_shipment_lines.unit_of_measure%type;

15742: l_pre_rcv_flag VARCHAR2(1);
15743: l_lcm_shipment_flag VARCHAR2(1);
15744: l_lsl_exists NUMBER := 0;
15745: l_rsl_qty NUMBER;
15746: l_rsl_uom rcv_shipment_lines.unit_of_measure%type;
15747: -- Bug 7607281
15748: l_po_currency po_headers_all.currency_code%type;
15749: l_po_rate_type po_headers_all.rate_type%type;
15750: l_po_rate_date po_headers_all.rate_date%type;

Line 15752: l_sec_rsl_uom rcv_shipment_lines.secondary_unit_of_measure%type;

15748: l_po_currency po_headers_all.currency_code%type;
15749: l_po_rate_type po_headers_all.rate_type%type;
15750: l_po_rate_date po_headers_all.rate_date%type;
15751: l_sec_rsl_qty NUMBER;
15752: l_sec_rsl_uom rcv_shipment_lines.secondary_unit_of_measure%type;
15753: l_lsl_id NUMBER;
15754: l_rate NUMBER;
15755: l_po_rate NUMBER;
15756: v_sobid NUMBER;

Line 15847: FROM rcv_shipment_lines

15843: IF (x_asn_type = 'LCM') THEN /* LCM import */
15844: --
15845: SELECT count(1)
15846: INTO l_lsl_exists
15847: FROM rcv_shipment_lines
15848: WHERE lcm_shipment_line_id is not null
15849: AND lcm_shipment_line_id = x_cascaded_table(n).lcm_shipment_line_id;
15850:
15851: asn_debug.put_line('Checking RSL: l_lsl_exists => ' || l_lsl_exists, null, 14);

Line 15886: FROM rcv_shipment_lines rsl

15882: rsl.secondary_quantity_shipped,
15883: rsl.secondary_unit_of_measure,
15884: rsl.lcm_shipment_line_id
15885: INTO l_rsl_qty, l_rsl_uom, l_sec_rsl_qty, l_sec_rsl_uom, l_lsl_id
15886: FROM rcv_shipment_lines rsl
15887: WHERE rsl.shipment_line_id = x_cascaded_table(n).shipment_line_id;
15888: --
15889: IF (l_rsl_qty <> x_cascaded_table(n).quantity) THEN
15890: --