DBA Data[Home] [Help]

APPS.RCV_RMA_TRANSACTIONS dependencies on OE_TRANSACTION_TYPES_ALL

Line 649: oe_transaction_types_all oett

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'
653: AND oel.line_type_id = oett.transaction_type_id

Line 1059: oe_transaction_types_all olt,

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
1063: WHERE oeh.header_id = v_header_id