DBA Data[Home] [Help]

APPS.GMP_APS_DS_PULL dependencies on DUAL

Line 3036: FROM dual ;

3032:
3033: SELECT DECODE(porigination_type,1,NULL,porder_no) ,
3034: DECODE(porigination_type,1,porder_no,NULL)
3035: INTO t_order_number, t_wip_entity_name
3036: FROM dual ;
3037:
3038: statement_demands :=
3039: ' INSERT INTO msc_st_demands ( '
3040: ||' organization_id, inventory_item_id, sr_instance_id, '

Line 5349: INTO cur_time FROM sys.dual ;

5345:
5346: cur_time VARCHAR2(25) := NULL ;
5347: BEGIN
5348: SELECT to_char(sysdate,'DD-MON-RRRR HH24:MI:SS')
5349: INTO cur_time FROM sys.dual ;
5350:
5351: log_message(cur_time);
5352: EXCEPTION
5353: WHEN OTHERS THEN