DBA Data[Home] [Help]

APPS.INV_RCV_TXN_MATCH dependencies on OE_ORDER_LINES_ALL

Line 1146: FROM oe_order_lines_all oel

1142: , To_number(NULL)
1143: , To_number(NULL)
1144: , To_char(NULL)
1145: , To_char(NULL)
1146: FROM oe_order_lines_all oel
1147: , oe_order_headers_all oeh
1148: --, wf_item_activity_statuses wf
1149: --, wf_process_activities wpa
1150: WHERE oel.header_id = oeh.header_id

Line 1189: FROM oe_order_lines_all oel

1185: ,v_project_id NUMBER
1186: ,v_task_id NUMBER)
1187: IS
1188: SELECT COUNT(*)
1189: FROM oe_order_lines_all oel
1190: , oe_order_headers_all oeh
1191: --, wf_item_activity_statuses wf
1192: --, wf_process_activities wpa
1193: WHERE oel.header_id = oeh.header_id

Line 2259: SELECT uom_code INTO l_rma_uom -- 14776842 In oe_order_lines_all, it only keep uom code

2255: print_debug('task_id : ' || temp_cascaded_table(current_n).task_id);
2256: print_debug('unit_of_measure : ' || temp_cascaded_table(current_n).unit_of_measure); --14776842
2257: END IF;
2258:
2259: SELECT uom_code INTO l_rma_uom -- 14776842 In oe_order_lines_all, it only keep uom code
2260: FROM mtl_units_of_measure WHERE unit_of_measure=temp_cascaded_table(current_n).unit_of_measure AND ROWNUM=1;
2261: IF (l_debug = 1) THEN
2262: print_debug('l_rma_uom : ' || l_rma_uom);
2263: END IF;

Line 3134: --bug3592116 for RMA the uom code is got from oe_order_lines_all but we need to get

3130: l_parent_id := x_MatchedRec.shipment_line_id;
3131: ELSIF p_match_type = 'RMA' THEN
3132: l_receipt_source_code := x_MatchedRec.receipt_source_code;
3133: l_parent_id := x_MatchedRec.oe_order_line_id;
3134: --bug3592116 for RMA the uom code is got from oe_order_lines_all but we need to get
3135: --unit_of_measure to convert the rma line quantity to user input qty.
3136: SELECT unit_of_measure INTO l_rma_uom
3137: FROM mtl_units_of_measure
3138: WHERE uom_code = x_MatchedRec.unit_of_measure;