DBA Data[Home] [Help]

APPS.WIP_FLOW_UTILITIES dependencies on DUAL

Line 117: from sys.dual

113:
114:
115: x_success := 0;
116: select 1 into x_success
117: from sys.dual
118: where Sub_Rec.substitution_type_id in (
119: select lookup_code from mfg_lookups
120: where lookup_type = 'WIP_SUBSTITUTION_TYPE') ;
121:

Line 881: from dual ;

877:
878: /* We enter this section only if the scheduled_flag = 3 or if it
879: passed all the validation for scheduled_flag = 2 */
880: Select wip_entities_s.nextval into x_wip_entity_id
881: from dual ;
882:
883: x_success := Create_Flow_Schedule(
884: x_wip_entity_id,
885: flow_rec.organization_id,

Line 1478: from sys.dual ;

1474: x_new_txn_hdr number;
1475: begin
1476:
1477: select MTL_MATERIAL_TRANSACTIONS_S.nextval into x_new_txn_hdr
1478: from sys.dual ;
1479:
1480:
1481: Update Mtl_transactions_interface
1482: set TRANSACTION_HEADER_ID = x_new_txn_hdr,