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.RCV_ROI_TRANSACTION dependencies on RCV_SHIPMENT_LINES

Line 3449: l_shipment_line_status_code rcv_shipment_lines.shipment_line_status_code%TYPE;

3445: x_allow_rate_override VARCHAR2(1);
3446: /* Bug# 1548597 */
3447: x_secondary_available_qty NUMBER := 0;
3448: l_receipt_source_code rcv_shipment_headers.receipt_source_code%TYPE;
3449: l_shipment_line_status_code rcv_shipment_lines.shipment_line_status_code%TYPE;
3450: l_asn_line_flag rcv_shipment_lines.asn_line_flag%TYPE;
3451: l_asn_exists_code rcv_parameters.receipt_asn_exists_code%TYPE;
3452: l_does_asn_exist VARCHAR2(1) := 'N';
3453: l_asn_count NUMBER := 0;

Line 3450: l_asn_line_flag rcv_shipment_lines.asn_line_flag%TYPE;

3446: /* Bug# 1548597 */
3447: x_secondary_available_qty NUMBER := 0;
3448: l_receipt_source_code rcv_shipment_headers.receipt_source_code%TYPE;
3449: l_shipment_line_status_code rcv_shipment_lines.shipment_line_status_code%TYPE;
3450: l_asn_line_flag rcv_shipment_lines.asn_line_flag%TYPE;
3451: l_asn_exists_code rcv_parameters.receipt_asn_exists_code%TYPE;
3452: l_does_asn_exist VARCHAR2(1) := 'N';
3453: l_asn_count NUMBER := 0;
3454: l_dist_count number; /* Bug#3746516 */

Line 4422: rcv_shipment_lines rsl

4418: FROM po_line_locations pll,
4419: po_lines pl,
4420: po_headers ph,
4421: rcv_shipment_headers rsh,
4422: rcv_shipment_lines rsl
4423: WHERE rsh.shipment_header_id = temp_cascaded_table(current_n).shipment_header_id
4424: AND rsl.shipment_line_id = temp_cascaded_table(current_n).shipment_line_id
4425: AND rsl.po_header_id = temp_cascaded_table(current_n).po_header_id
4426: AND rsl.po_line_id = temp_cascaded_table(current_n).po_line_id

Line 4762: rcv_shipment_lines rsl

4758:
4759: SELECT COUNT(*)
4760: INTO l_asn_count
4761: FROM rcv_shipment_headers rsh,
4762: rcv_shipment_lines rsl
4763: WHERE rsh.shipment_header_id = rsl.shipment_header_id
4764: AND NVL(rsh.asn_type, 'STD') IN ('ASN','ASBN') --4287932
4765: AND NVL(rsl.shipment_line_status_code, 'EXPECTED') NOT IN('CANCELLED', 'FULLY RECEIVED')
4766: AND rsl.po_line_location_id = x_shipmentdistributionrec.line_location_id;

Line 10062: AND NOT EXISTS (SELECT 1 from rcv_shipment_lines

10058:
10059: asn_debug.put_line('Deleting the rsh record with shipment_header_id = '||l_ship_head_id);
10060: DELETE FROM rcv_shipment_headers rsh
10061: WHERE shipment_header_id=l_ship_head_id
10062: AND NOT EXISTS (SELECT 1 from rcv_shipment_lines
10063: WHERE shipment_header_id=rsh.shipment_header_id)
10064: AND NOT EXISTS (SELECT 1 from rcv_transactions rt
10065: WHERE rt.shipment_header_id = rsh.shipment_header_id);
10066: END IF;

Line 10445: rcv_shipment_lines rsl,

10441: rt.quantity qty,
10442: 0 interface_available_qty
10443: FROM rcv_supply rsup,
10444: rcv_transactions rt,
10445: rcv_shipment_lines rsl,
10446: po_headers poh,
10447: po_lines pol
10448: WHERE rt.transaction_id = v_parent_trx_id
10449: AND rsup.to_organization_id = NVL(v_to_organization_id, rsup.to_organization_id)

Line 10552: rcv_shipment_lines rsl,

10548: rt.quantity qty,
10549: 0 interface_available_qty
10550: FROM rcv_supply rsup,
10551: rcv_transactions rt,
10552: rcv_shipment_lines rsl,
10553: po_headers poh,
10554: po_lines pol,
10555: po_distributions pod
10556: WHERE rt.transaction_id = v_parent_trx_id

Line 10667: rcv_shipment_lines rsl,

10663: rt.quantity qty,
10664: 0 interface_available_qty
10665: FROM rcv_supply rsup,
10666: rcv_transactions rt,
10667: rcv_shipment_lines rsl,
10668: po_headers poh,
10669: po_lines pol,
10670: po_distributions pod
10671: WHERE rt.transaction_id = v_parent_trx_id

Line 10775: rcv_shipment_lines rsl,

10771: rt.quantity qty,
10772: 0 interface_available_qty
10773: FROM rcv_supply rsup,
10774: rcv_transactions rt,
10775: rcv_shipment_lines rsl,
10776: po_headers poh,
10777: po_lines pol,
10778: po_distributions pod
10779: WHERE rt.transaction_id = v_parent_trx_id

Line 12786: rcv_shipment_lines rsl,

12782: rt.customer_id,
12783: rt.customer_site_id,
12784: rt.source_document_code
12785: FROM rcv_transactions rt,
12786: rcv_shipment_lines rsl,
12787: rcv_supply rsup
12788: WHERE rt.transaction_id = v_parent_trx_id
12789: AND rt.transaction_id = rsup.rcv_transaction_id
12790: AND rsup.supply_type_code = 'RECEIVING'

Line 13395: rcv_shipment_lines rsl,

13391: rt.wip_line_id,
13392: rt.bom_resource_id,
13393: rsl.ussgl_transaction_code
13394: FROM rcv_transactions rt,
13395: rcv_shipment_lines rsl,
13396: po_headers poh,
13397: po_lines pol
13398: WHERE rt.transaction_id = v_parent_trx_id
13399: AND rt.organization_id = NVL(v_to_organization_id, rt.organization_id)

Line 14223: rcv_shipment_lines rsl

14219: INTO l_transaction_uom,
14220: l_item_id,
14221: l_primary_uom
14222: FROM rcv_transactions rt,
14223: rcv_shipment_lines rsl
14224: WHERE rsl.shipment_line_id = rt.shipment_line_id
14225: AND rt.transaction_id = x_po_correctrec.rcv_transaction_id;
14226:
14227: SELECT NVL(SUM(interface_transaction_qty),0)

Line 14570: rcv_shipment_lines rsl,

14566: rt.po_distribution_id,
14567: rt.destination_type_code,
14568: rsl.ussgl_transaction_code
14569: FROM rcv_transactions rt,
14570: rcv_shipment_lines rsl,
14571: po_headers poh,
14572: po_lines pol
14573: WHERE rt.transaction_id = v_parent_trx_id
14574: AND rt.organization_id = NVL(v_to_organization_id, rt.organization_id)

Line 15598: rcv_shipment_lines rsl

15594: rt.customer_site_id,
15595: rt.source_document_code,
15596: rt.job_id
15597: FROM rcv_transactions rt,
15598: rcv_shipment_lines rsl
15599: WHERE rt.transaction_id = v_parent_trx_id
15600: AND ( rt.transaction_type IN('RECEIVE', 'TRANSFER', 'ACCEPT', 'REJECT', 'MATCH')
15601: OR ( rt.transaction_type IN('RETURN TO VENDOR', 'RETURN TO CUSTOMER')
15602: AND NOT EXISTS(SELECT 'rtv to processed matched unordered receipt'

Line 16146: FROM rcv_shipment_lines

16142: SELECT quantity_shipped,
16143: secondary_quantity_shipped
16144: INTO l_quantity_shipped,
16145: l_secondary_quantity_shipped
16146: FROM rcv_shipment_lines
16147: WHERE shipment_header_id = x_cascaded_table(n).shipment_header_id
16148: AND shipment_line_id = x_cascaded_table(n).shipment_line_id;
16149: EXCEPTION
16150: WHEN OTHERS THEN

Line 17165: l_rsl_uom rcv_shipment_lines.unit_of_measure%type;

17161: l_pre_rcv_flag VARCHAR2(1);
17162: l_lcm_shipment_flag VARCHAR2(1);
17163: l_lsl_exists NUMBER := 0;
17164: l_rsl_qty NUMBER;
17165: l_rsl_uom rcv_shipment_lines.unit_of_measure%type;
17166: -- Bug 7607281
17167: l_sec_rsl_qty NUMBER;
17168: l_sec_rsl_uom rcv_shipment_lines.secondary_unit_of_measure%type;
17169: l_lsl_id NUMBER;

Line 17168: l_sec_rsl_uom rcv_shipment_lines.secondary_unit_of_measure%type;

17164: l_rsl_qty NUMBER;
17165: l_rsl_uom rcv_shipment_lines.unit_of_measure%type;
17166: -- Bug 7607281
17167: l_sec_rsl_qty NUMBER;
17168: l_sec_rsl_uom rcv_shipment_lines.secondary_unit_of_measure%type;
17169: l_lsl_id NUMBER;
17170: v_sobid NUMBER;
17171: l_lcm_date rcv_shipment_headers.conversion_date%type;
17172: p_api_version NUMBER := 1.0;

Line 17263: FROM rcv_shipment_lines

17259: IF (x_asn_type = 'LCM') THEN /* LCM import */
17260: --
17261: SELECT count(1)
17262: INTO l_lsl_exists
17263: FROM rcv_shipment_lines
17264: WHERE lcm_shipment_line_id is not null
17265: AND lcm_shipment_line_id = x_cascaded_table(n).lcm_shipment_line_id;
17266:
17267: asn_debug.put_line('Checking RSL: l_lsl_exists => ' || l_lsl_exists, null, 14);

Line 17302: FROM rcv_shipment_lines rsl

17298: rsl.secondary_quantity_shipped,
17299: rsl.secondary_unit_of_measure,
17300: rsl.lcm_shipment_line_id
17301: INTO l_rsl_qty, l_rsl_uom, l_sec_rsl_qty, l_sec_rsl_uom, l_lsl_id
17302: FROM rcv_shipment_lines rsl
17303: WHERE rsl.shipment_line_id = x_cascaded_table(n).shipment_line_id;
17304: --
17305: IF (l_rsl_qty <> x_cascaded_table(n).quantity) THEN
17306: --

Line 17645: l_mmt_transaction_id rcv_shipment_lines.mmt_transaction_id%type;

17641: PROCEDURE validate_shipment_source(
17642: x_cascaded_table IN OUT NOCOPY rcv_roi_preprocessor.cascaded_trans_tab_type,
17643: n IN BINARY_INTEGER
17644: ) IS
17645: l_mmt_transaction_id rcv_shipment_lines.mmt_transaction_id%type;
17646: l_record_exists number := 0;
17647: x_error_status VARCHAR2(1);
17648: BEGIN
17649: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN

Line 17660: FROM rcv_shipment_lines

17656:
17657: IF x_cascaded_table(n).shipment_line_id IS NOT NULL THEN
17658: SELECT mmt_transaction_id
17659: INTO l_mmt_transaction_id
17660: FROM rcv_shipment_lines
17661: WHERE shipment_line_id = x_cascaded_table(n).shipment_line_id;
17662:
17663: IF l_mmt_transaction_id IS NOT NULL THEN
17664: SELECT COUNT(*)