DBA Data[Home] [Help]

APPS.INV_WORKFLOW dependencies on OE_TRANSACTION_TYPES_ALL

Line 247: FROM oe_transaction_types_all

243: /* IF (ic_order_type_cogs IS NULL) THEN
244: BEGIN
245: SELECT NVL(cost_of_goods_sold_account, 0)
246: INTO v_order_type_cogs
247: FROM oe_transaction_types_all
248: WHERE transaction_type_id = TO_NUMBER(ic_order_type_id)a
249: AND 1 = 1;
250:
251: print_debug('Found v_order_type_cogs: ' || v_order_type_cogs, l_function_name);

Line 268: FROM oe_transaction_types_all

264: IF (ic_order_type_cogs IS NULL) AND (nvl(ic_order_line_id,0) <> 0) THEN
265: BEGIN
266: SELECT NVL(cost_of_goods_sold_account, 0)
267: INTO v_order_type_cogs
268: FROM oe_transaction_types_all
269: WHERE transaction_type_id = TO_NUMBER(ic_order_type_id)
270: AND 1 = 1;
271:
272: print_debug('Found v_order_type_cogs: ' || v_order_type_cogs, l_function_name);

Line 287: FROM oe_transaction_types_all

283: IF (ic_order_type_cogs IS NULL) AND (nvl(ic_order_line_id,0) = 0) THEN
284: BEGIN
285: SELECT NVL(cost_of_goods_sold_account, 0)
286: INTO v_order_type_cogs
287: FROM oe_transaction_types_all
288: WHERE transaction_type_id = TO_NUMBER(ic_order_type_id)
289: AND 1 = 1;
290:
291: SELECT org_id, order_source_id