DBA Data[Home] [Help]

APPS.GMI_MOVE_ORDER_LINE_UTIL dependencies on OE_TRANSACTION_TYPES_ALL

Line 2702: oe_transaction_types_all ta,

2698: SELECT COUNT(1)
2699: FROM ic_txn_request_lines mo,
2700: oe_order_lines_all l,
2701: oe_order_headers_all h,
2702: oe_transaction_types_all ta,
2703: oe_transaction_types_tl tt
2704: WHERE l.header_id = h.header_id
2705: AND l.line_id = mo.txn_source_line_id
2706: AND tt.transaction_type_id = ta.transaction_type_id

Line 2739: oe_transaction_types_all ta,

2735: mo.inventory_item_id
2736: FROM ic_txn_request_lines mo,
2737: oe_order_lines_all l,
2738: oe_order_headers_all h,
2739: oe_transaction_types_all ta,
2740: oe_transaction_types_tl tt
2741: WHERE l.header_id = h.header_id
2742: AND l.line_id = mo.txn_source_line_id
2743: AND tt.transaction_type_id = ta.transaction_type_id