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_ALL

Line 649: oe_order_lines_all oel,

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

Line 661: FROM oe_order_lines_all oela

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

Line 710: FROM oe_order_lines_all

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

Line 754: FROM oe_order_lines_all

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

Line 1059: oe_order_lines_all oel,

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

Line 1515: oe_order_lines_all oel,

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

Line 2559: x_oe_order_line_id oe_order_lines_all.line_id%type;

2555: x_val_open_ok BOOLEAN;
2556: -- Bug 12582249 add logic to check whether transaction date is earlier than shipment date
2557: x_parent_txn_id rcv_transactions.transaction_id%type;
2558: x_parent_txn_date rcv_transactions.transaction_date%type;
2559: x_oe_order_line_id oe_order_lines_all.line_id%type;
2560: x_oe_reference_order_line_id oe_order_lines_all.reference_line_id%type;
2561: x_so_issue_transaction_date mtl_material_transactions.transaction_date%type;
2562: x_item_id mtl_material_transactions.inventory_item_id%type;
2563: x_oe_reference_order_num oe_order_headers_all.order_number%type;

Line 2560: x_oe_reference_order_line_id oe_order_lines_all.reference_line_id%type;

2556: -- Bug 12582249 add logic to check whether transaction date is earlier than shipment date
2557: x_parent_txn_id rcv_transactions.transaction_id%type;
2558: x_parent_txn_date rcv_transactions.transaction_date%type;
2559: x_oe_order_line_id oe_order_lines_all.line_id%type;
2560: x_oe_reference_order_line_id oe_order_lines_all.reference_line_id%type;
2561: x_so_issue_transaction_date mtl_material_transactions.transaction_date%type;
2562: x_item_id mtl_material_transactions.inventory_item_id%type;
2563: x_oe_reference_order_num oe_order_headers_all.order_number%type;
2564: x_oe_reference_order_line varchar2(30);

Line 2696: FROM oe_order_lines_all oola

2692: x_oe_order_line_id := x_cascaded_table(n).oe_order_line_id;
2693: BEGIN
2694: SELECT oola.reference_line_id
2695: INTO x_oe_reference_order_line_id
2696: FROM oe_order_lines_all oola
2697: WHERE oola.line_id = x_oe_order_line_id
2698: AND oola.return_context = 'ORDER';
2699: EXCEPTION
2700: WHEN OTHERS THEN

Line 2726: FROM oe_order_headers_all ooha, oe_order_lines_all oola

2722: OR x_so_issue_transaction_date is null -- bug 14168623 if so not being shipped then not allow to do RMA
2723: THEN
2724: SELECT ooha.order_number, oola.line_number||'.'||oola.shipment_number
2725: INTO x_oe_reference_order_num, x_oe_reference_order_line
2726: FROM oe_order_headers_all ooha, oe_order_lines_all oola
2727: WHERE ooha.header_id = oola.header_id
2728: AND oola.line_id = x_oe_reference_order_line_id;
2729:
2730: x_cascaded_table(n).error_status := rcv_error_pkg.g_ret_sts_error;

Line 2902: x_item_id_po oe_order_lines_all.inventory_item_id%TYPE;

2898: ) IS -- bug 608353
2899: x_progress VARCHAR2(3);
2900: x_inventory_item mtl_system_items.inventory_item_id%TYPE;
2901: x_organization_id mtl_system_items.organization_id%TYPE;
2902: x_item_id_po oe_order_lines_all.inventory_item_id%TYPE;
2903: x_error_status VARCHAR2(1);
2904: BEGIN
2905: x_error_status := rcv_error_pkg.g_ret_sts_error;
2906: x_progress := '000';

Line 2951: FROM oe_order_lines_all

2947: END IF;
2948:
2949: SELECT NVL(MAX(inventory_item_id), -9999)
2950: INTO x_item_id_po
2951: FROM oe_order_lines_all
2952: WHERE line_id = x_item_id_record.po_line_id
2953: AND inventory_item_id = x_item_id_record.item_id;
2954:
2955: IF (x_item_id_po = -9999) THEN

Line 2976: FROM oe_order_lines_all

2972: thru ROI. If required we will incorporate later.
2973: */
2974: SELECT NVL(MAX(inventory_item_id), -9999)
2975: INTO x_item_id_po
2976: FROM oe_order_lines_all
2977: WHERE line_id = x_item_id_record.po_line_id
2978: AND inventory_item_id = x_item_id_record.item_id;
2979:
2980: IF (x_item_id_po <> x_item_id_record.item_id) THEN

Line 3052: FROM oe_order_lines_all

3048: return without any error, else return with error
3049: */
3050: SELECT NVL(MAX(line_id), 0)
3051: INTO x_inventory_item
3052: FROM oe_order_lines_all
3053: WHERE line_id = x_item_revision_record.po_line_id
3054: AND NVL(item_revision, x_item_revision_record.item_revision) = x_item_revision_record.item_revision;
3055:
3056: IF (x_inventory_item <> 0) THEN

Line 3104: FROM oe_order_lines_all

3100: -- Check whether rma revision matches this revision if rma revision is not null
3101:
3102: SELECT NVL(MAX(line_id), 0)
3103: INTO x_inventory_item
3104: FROM oe_order_lines_all
3105: WHERE line_id = x_item_revision_record.po_line_id
3106: AND NVL(item_revision, x_item_revision_record.item_revision) = x_item_revision_record.item_revision;
3107:
3108: IF (x_inventory_item = 0) THEN

Line 3132: x_order_line_id oe_order_lines_all.line_id%TYPE;

3128: n IN BINARY_INTEGER
3129: ) IS
3130: x_customer_item_num rcv_transactions_interface.customer_item_num%TYPE;
3131: x_customer_id rcv_transactions_interface.customer_id%TYPE;
3132: x_order_line_id oe_order_lines_all.line_id%TYPE;
3133: BEGIN
3134: IF (x_cascaded_table(n).error_status NOT IN('S', 'W')) THEN
3135: RETURN;
3136: END IF;

Line 3146: FROM oe_order_lines_all oel,

3142: -- check customer item number
3143: IF (x_cascaded_table(n).customer_item_num IS NOT NULL) THEN
3144: SELECT NVL(MAX(oel.line_id), 0)
3145: INTO x_order_line_id
3146: FROM oe_order_lines_all oel,
3147: mtl_customer_items mci
3148: WHERE oel.line_id = x_cascaded_table(n).oe_order_line_id
3149: AND oel.ordered_item_id = mci.customer_item_id
3150: AND mci.customer_item_number = x_cascaded_table(n).customer_item_num;

Line 3254: FROM oe_order_lines_all

3250: END IF;
3251:
3252: SELECT NVL(MAX(order_quantity_uom), 'notfound')
3253: INTO x_unit_meas_lookup_code_lines
3254: FROM oe_order_lines_all
3255: WHERE line_id = x_uom_record.po_line_id;
3256:
3257: IF (x_unit_meas_lookup_code_lines <> 'notfound')
3258: AND (x_unit_meas_lookup_code_lines <> x_uom_record.unit_of_measure) THEN

Line 3330: FROM oe_order_lines_all

3326: END IF;
3327:
3328: SELECT item_revision
3329: INTO x_item_revision_record.item_revision
3330: FROM oe_order_lines_all
3331: WHERE oe_order_lines_all.line_id = x_item_revision_record.po_line_id;
3332: END IF;
3333:
3334: IF x_item_revision_record.item_revision IS NULL THEN

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

3327:
3328: SELECT item_revision
3329: INTO x_item_revision_record.item_revision
3330: FROM oe_order_lines_all
3331: WHERE oe_order_lines_all.line_id = x_item_revision_record.po_line_id;
3332: END IF;
3333:
3334: IF x_item_revision_record.item_revision IS NULL THEN
3335: IF (g_asn_debug = 'Y') THEN