APPS.MSC_X_UTIL dependencies on DUAL

Line 624: from dual;

620: -- Get session id
621: --===============
622: select mrp_atp_schedule_temp_s.nextval
623: into l_session_id
624: from dual;
625:
626: BEGIN
627:
628: MSC_SATP_FUNC.GET_REGIONS(l_tp_customer_site_id,

Line 827: from dual;

823: --===============
824: BEGIN
825: select mrp_atp_schedule_temp_s.nextval
826: into l_session_id
827: from dual;
828:
829: MSC_ATP_PROC.ATP_Intransit_LT(
830: 2 , --- Destination
831: l_session_id, -- session_id

Line 900: FROM dual;

896:
897:
898: select to_number(to_char(sysdate, 'j'))
899: INTO jul_ship_date
900: FROM dual;
901:
902:
903: /* This function returns the lead time between an OEM org and a
904: ** customer/customer site.

Line 927: INTO jul_rcpt_date FROM dual;

923: END;
924:
925:
926: select to_number(to_char(rcpt_date, 'j'))
927: INTO jul_rcpt_date FROM dual;
928:
929: lead_time := GREATEST(jul_rcpt_date - jul_ship_date, 0);
930:
931: return lead_time;