DBA Data[Home] [Help]

APPS.WSH_PICKING_BATCHES_GRP dependencies on OE_TRANSACTION_TYPES_TL

Line 107: FROM oe_transaction_types_tl

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

Line 112: FROM oe_transaction_types_tl

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