APPS.CSP_SCH_INT_PVT dependencies on CSP_CARRIER_DELIVERY_TIMES

Line 2879: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT

2875: CURSOR csp_ship_methodes(from_org varchar2,to_org varchar2) IS
2876: SELECT ISM.SHIP_METHOD,NVL(ISM.COST_PER_UNIT_LOAD_WEIGHT,0)
2877: ,CDT.FREIGHT_CODE,CDT.LEAD_TIME,CDT.LEAD_TIME_UOM,CDT.DELIVERY_TIME
2878: ,CDT.CUTOFF_TIME,CDT.TIMEZONE_ID,CDT.SAFETY_ZONE
2879: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT
2880: WHERE ISM.FROM_ORGANIZATION_ID = from_org
2881: AND ISM.TO_ORGANIZATION_ID = to_org
2882: AND CDT.ORGANIZATION_ID = from_org
2883: AND CDT.SHIPPING_METHOD = ISM.SHIP_METHOD;

Line 3265: FROM CSP_CARRIER_DELIVERY_TIMES CDT

3261: x_msg_count OUT NOCOPY NUMBER) IS
3262: CURSOR C1(c_relation_id NUMBER) IS
3263: SELECT CDT.LEAD_TIME,CDT.LEAD_TIME_UOM,CDT.DELIVERY_TIME
3264: ,CDT.CUTOFF_TIME,CDT.TIMEZONE_ID,CDT.SAFETY_ZONE
3265: FROM CSP_CARRIER_DELIVERY_TIMES CDT
3266: WHERE CDT.relation_ship_id = c_relation_id;
3267: I NUMBER;
3268: l_hours NUMBER;
3269: l_days NUMBER;

Line 3606: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT

3602: ,x_msg_count OUT NOCOPY NUMBER) IS
3603: CURSOR C3(from_org varchar2,to_org varchar2) IS
3604: SELECT NVL(ISM.COST_PER_UNIT_LOAD_WEIGHT,0),
3605: CDT.RELATION_SHIP_ID,CDT.CUTOFF_TIME,CDT.TIMEZONE_ID,ISM.SHIP_METHOD
3606: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT
3607: WHERE ISM.FROM_ORGANIZATION_ID = from_org
3608: AND ISM.TO_ORGANIZATION_ID = to_org
3609: AND CDT.ORGANIZATION_ID = from_org
3610: AND CDT.SHIPPING_METHOD = ISM.SHIP_METHOD;

Line 5425: from CSP_CARRIER_DELIVERY_TIMES

5421:
5422: cursor get_cutoff_time(c_org_id number,
5423: c_ship_method_code varchar2) IS
5424: select cutoff_time,timezone_id
5425: from CSP_CARRIER_DELIVERY_TIMES
5426: where ORGANIZATION_ID = c_org_id
5427: and SHIPPING_METHOD = c_ship_method_code;
5428:
5429: BEGIN