DBA Data[Home] [Help]

APPS.CTO_WORKFLOW_API_PK dependencies on DUAL

Line 646: FROM DUAL;

642: SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
643: NULL,
644: SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
645: INTO l_original_org_id
646: FROM DUAL;
647:
648:
649:
650: change_status_batch (

Line 3659: from dual;

3655:
3656: l_stmt_num :=70;
3657: select decode(l_make_flag,'Y',1,0)+decode(l_buy_fg,'Y',1,0)+decode(l_xfer_fg,'Y',1,0)
3658: into l_hetro
3659: from dual;
3660:
3661: l_stmt_num:=80;
3662: If l_onhand_fg = 'Y' and
3663: l_rsv_rec(l_inv_src_id).primary_reservation_quantity >= p_ordered_quantity Then