DBA Data[Home] [Help]

APPS.WSH_PICKING_BATCHES_GRP dependencies on OE_TRANSACTION_TYPES_TL

Line 109: FROM oe_transaction_types_tl

105:
106:
107: CURSOR Get_Order_Type_id(p_type_id IN NUMBER ,p_type_name IN VARCHAR2) IS
108: SELECT transaction_type_id
109: FROM oe_transaction_types_tl
110: WHERE p_type_id IS NOT NULL
111: AND transaction_type_id = p_type_id
112: UNION All
113: SELECT transaction_type_id

Line 114: FROM oe_transaction_types_tl

110: WHERE p_type_id IS NOT NULL
111: AND transaction_type_id = p_type_id
112: UNION All
113: SELECT transaction_type_id
114: FROM oe_transaction_types_tl
115: WHERE p_type_id IS NULL
116: AND name = p_type_name;
117:
118: