APPS.OE_INV_IFACE_PVT dependencies on DUAL

Line 259: FROM DUAL;

255: 'C',SYSDATE,
256: 'S',nvl(l_line_rec.schedule_ship_date,SYSDATE),
257: l_ordered_date)
258: INTO l_trx_date_for_inv_iface
259: FROM DUAL;
260:
261: IF l_debug_level > 0 THEN
262: OE_DEBUG_PUB.add('Transaction Date derived from system parameter setup is '||l_trx_date_for_inv_iface,1);
263: END IF;

Line 348: FROM dual;

344: -- we will use this transaction_header_id for all
345: -- interface lines
346: SELECT mtl_material_transactions_s.nextval
347: INTO l_transaction_header_id
348: FROM dual;
349:
350: l_transaction_interface_id := l_transaction_header_id;
351:
352: l_transaction_reference := l_line_rec.header_id;

Line 657: FROM dual;

653: IF ( l_process_org = 0 ) THEN */
654:
655: SELECT oe_transactions_iface_s.nextval
656: INTO l_source_line_id
657: FROM dual;
658:
659: IF l_lot = 'Y' THEN
660: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE
661: (

Line 983: FROM dual;

979: WHERE code_combination_id = l_trans_acc;
980:
981: SELECT mtl_material_transactions_s.nextval
982: INTO l_transaction_interface_id
983: FROM dual;
984: -- for use when looping or used by the second
985: -- insert into mtl_transactions_interface
986: -- interface_id need to be unique for each interface record
987:

Line 1139: FROM dual;

1135: -- mtl_transactions_interface table
1136: IF ( l_process_org = 0 ) THEN */
1137: SELECT oe_transactions_iface_s.nextval
1138: INTO l_source_line_id
1139: FROM dual;
1140:
1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.add( 'INV IFACE: INSERTING RECORD - 2' , 5 ) ;
1143: