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_RMA_TRANSACTIONS dependencies on OE_ORDER_LINES

Line 26: oe_order_lines oel,

22: oeh.conversion_rate currency_conversion_rate,
23: oel.subinventory subinventory,
24: oel.ship_from_org_id deliver_to_location_id
25: FROM oe_order_headers oeh,
26: oe_order_lines oel,
27: mtl_system_items msi
28: WHERE oel.line_id = v_line_id
29: AND oel.header_id = oeh.header_id
30: AND oel.booked_flag = 'Y'

Line 648: oe_order_lines_all oel,

644:
645: SELECT DISTINCT oeh.header_id
646: INTO x_cascaded_table(n).oe_order_header_id
647: FROM oe_order_headers_all oeh,
648: oe_order_lines_all oel,
649: oe_transaction_types_all oett
650: WHERE oeh.order_number = x_cascaded_table(n).oe_order_num
651: AND oeh.header_id = oel.header_id
652: AND oel.line_category_code = 'RETURN'

Line 660: FROM oe_order_lines_all oela

656: AND oeh.booked_flag = 'Y'
657: AND ( ( oeh.ship_from_org_id IS NOT NULL
658: AND oeh.ship_from_org_id = x_cascaded_table(n).to_organization_id)
659: OR EXISTS(SELECT 1
660: FROM oe_order_lines_all oela
661: WHERE oela.header_id = oeh.header_id
662: AND oela.ship_from_org_id = x_cascaded_table(n).to_organization_id));
663:
664: IF (g_asn_debug = 'Y') THEN

Line 709: FROM oe_order_lines_all

705: SELECT line_id,
706: inventory_item_id
707: INTO my_line_id,
708: my_item_id
709: FROM oe_order_lines_all
710: WHERE header_id = x_cascaded_table(n).oe_order_header_id
711: AND line_number = x_cascaded_table(n).document_line_num
712: -- pjiang: extra filter for oe line split
713: AND flow_status_code = 'AWAITING_RETURN';

Line 753: FROM oe_order_lines_all

749: AND x_cascaded_table(n).oe_order_line_id IS NOT NULL
750: AND x_cascaded_table(n).oe_order_header_id IS NOT NULL THEN
751: SELECT line_number
752: INTO x_cascaded_table(n).document_line_num
753: FROM oe_order_lines_all
754: WHERE line_id = x_cascaded_table(n).oe_order_line_id;
755: END IF;
756: END derive_document_line_info;
757:

Line 1058: oe_order_lines_all oel,

1054: oel.inventory_item_id item_id,
1055: mum.unit_of_measure,
1056: msi.description description
1057: FROM oe_order_headers_all oeh,
1058: oe_order_lines_all oel,
1059: oe_transaction_types_all olt,
1060: oe_transaction_types_tl t,
1061: mtl_units_of_measure_tl mum,
1062: mtl_system_items msi

Line 1512: oe_order_lines_all oel,

1508: x_flow_status_code,
1509: x_ordered_quantity,
1510: x_shipped_quantity
1511: FROM oe_order_headers_all oeh,
1512: oe_order_lines_all oel,
1513: mtl_customer_items mci
1514: WHERE oeh.header_id = x_cascaded_table(n).oe_order_header_id
1515: AND oeh.header_id = oel.header_id
1516: AND oel.line_number = NVL(x_cascaded_table(n).oe_order_line_num, oel.line_number)

Line 2763: x_item_id_po oe_order_lines_all.inventory_item_id%TYPE;

2759: ) IS -- bug 608353
2760: x_progress VARCHAR2(3);
2761: x_inventory_item mtl_system_items.inventory_item_id%TYPE;
2762: x_organization_id mtl_system_items.organization_id%TYPE;
2763: x_item_id_po oe_order_lines_all.inventory_item_id%TYPE;
2764: x_error_status VARCHAR2(1);
2765: BEGIN
2766: x_error_status := rcv_error_pkg.g_ret_sts_error;
2767: x_progress := '000';

Line 2811: FROM oe_order_lines_all

2807: END IF;
2808:
2809: SELECT NVL(MAX(inventory_item_id), -9999)
2810: INTO x_item_id_po
2811: FROM oe_order_lines_all
2812: WHERE line_id = x_item_id_record.po_line_id
2813: AND inventory_item_id = x_item_id_record.item_id;
2814:
2815: IF (x_item_id_po = -9999) THEN

Line 2836: FROM oe_order_lines_all

2832: thru ROI. If required we will incorporate later.
2833: */
2834: SELECT NVL(MAX(inventory_item_id), -9999)
2835: INTO x_item_id_po
2836: FROM oe_order_lines_all
2837: WHERE line_id = x_item_id_record.po_line_id
2838: AND inventory_item_id = x_item_id_record.item_id;
2839:
2840: IF (x_item_id_po <> x_item_id_record.item_id) THEN

Line 2912: FROM oe_order_lines_all

2908: return without any error, else return with error
2909: */
2910: SELECT NVL(MAX(line_id), 0)
2911: INTO x_inventory_item
2912: FROM oe_order_lines_all
2913: WHERE line_id = x_item_revision_record.po_line_id
2914: AND NVL(item_revision, x_item_revision_record.item_revision) = x_item_revision_record.item_revision;
2915:
2916: IF (x_inventory_item <> 0) THEN

Line 2964: FROM oe_order_lines_all

2960: -- Check whether rma revision matches this revision if rma revision is not null
2961:
2962: SELECT NVL(MAX(line_id), 0)
2963: INTO x_inventory_item
2964: FROM oe_order_lines_all
2965: WHERE line_id = x_item_revision_record.po_line_id
2966: AND NVL(item_revision, x_item_revision_record.item_revision) = x_item_revision_record.item_revision;
2967:
2968: IF (x_inventory_item = 0) THEN

Line 2992: x_order_line_id oe_order_lines_all.line_id%TYPE;

2988: n IN BINARY_INTEGER
2989: ) IS
2990: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;
2991: x_customer_id rcv_transactions_interface.customer_id%TYPE;
2992: x_order_line_id oe_order_lines_all.line_id%TYPE;
2993: BEGIN
2994: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
2995: RETURN;
2996: END IF;

Line 3006: FROM oe_order_lines_all oel,

3002: -- check customer item number
3003: IF (x_cascaded_table(n).customer_item_num IS NOT NULL) THEN
3004: SELECT NVL(MAX(oel.line_id), 0)
3005: INTO x_order_line_id
3006: FROM oe_order_lines_all oel,
3007: mtl_customer_items mci
3008: WHERE oel.line_id = x_cascaded_table(n).oe_order_line_id
3009: AND oel.ordered_item_id = mci.customer_item_id
3010: AND mci.customer_item_number = x_cascaded_table(n).customer_item_num;

Line 3114: FROM oe_order_lines_all

3110: END IF;
3111:
3112: SELECT NVL(MAX(order_quantity_uom), 'notfound')
3113: INTO x_unit_meas_lookup_code_lines
3114: FROM oe_order_lines_all
3115: WHERE line_id = x_uom_record.po_line_id;
3116:
3117: IF (x_unit_meas_lookup_code_lines <> 'notfound')
3118: AND (x_unit_meas_lookup_code_lines <> x_uom_record.unit_of_measure) THEN

Line 3168: if revision is null then try to pick up item_revision from oe_order_lines

3164: AND organization_id = x_item_revision_record.to_organization_id;
3165:
3166: /* If item is under revision control
3167:
3168: if revision is null then try to pick up item_revision from oe_order_lines
3169:
3170: if revision is still null and
3171: there are any destination_type=INVENTORY then
3172:

Line 3190: FROM oe_order_lines_all

3186: END IF;
3187:
3188: SELECT item_revision
3189: INTO x_item_revision_record.item_revision
3190: FROM oe_order_lines_all
3191: WHERE oe_order_lines_all.line_id = x_item_revision_record.po_line_id;
3192: END IF;
3193:
3194: IF x_item_revision_record.item_revision IS NULL THEN

Line 3191: WHERE oe_order_lines_all.line_id = x_item_revision_record.po_line_id;

3187:
3188: SELECT item_revision
3189: INTO x_item_revision_record.item_revision
3190: FROM oe_order_lines_all
3191: WHERE oe_order_lines_all.line_id = x_item_revision_record.po_line_id;
3192: END IF;
3193:
3194: IF x_item_revision_record.item_revision IS NULL THEN
3195: IF (g_asn_debug = 'Y') THEN