DBA Data[Home] [Help]

APPS.RCV_RMA_TRANSACTIONS dependencies on OE_TRANSACTION_TYPES_ALL

Line 650: oe_transaction_types_all oett

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

Line 1060: oe_transaction_types_all olt,

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