eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_SCH_INT_PVT dependencies on MTL_INTERORG_SHIP_METHODS

Line 4765: FROM MTL_INTERORG_SHIP_METHODS ISM,HR_ALL_ORGANIZATION_UNITS hao

4761: ,x_msg_count OUT NOCOPY NUMBER) IS
4762:
4763: cursor location_shipping_method_count(c_from_org_id number, c_to_location_id number) IS
4764: SELECT count(*)
4765: FROM MTL_INTERORG_SHIP_METHODS ISM,HR_ALL_ORGANIZATION_UNITS hao
4766: where hao.organization_id = c_from_org_id
4767: and ism.from_location_id = hao.location_id
4768: and ism.to_location_id = c_to_location_id;
4769:

Line 5310: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT

5306: CURSOR csp_ship_methodes(from_org varchar2,to_org varchar2) IS
5307: SELECT ISM.SHIP_METHOD,NVL(ISM.COST_PER_UNIT_LOAD_WEIGHT,0)
5308: ,CDT.FREIGHT_CODE,CDT.LEAD_TIME,CDT.LEAD_TIME_UOM,CDT.DELIVERY_TIME
5309: ,CDT.CUTOFF_TIME,CDT.TIMEZONE_ID,CDT.SAFETY_ZONE
5310: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT
5311: WHERE ISM.FROM_ORGANIZATION_ID = from_org
5312: AND ISM.TO_ORGANIZATION_ID = to_org
5313: AND CDT.ORGANIZATION_ID = from_org
5314: AND CDT.SHIPPING_METHOD = ISM.SHIP_METHOD;

Line 6031: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT

6027: ,x_msg_count OUT NOCOPY NUMBER) IS
6028: CURSOR C3(from_org varchar2,to_org varchar2) IS
6029: SELECT NVL(ISM.COST_PER_UNIT_LOAD_WEIGHT,0),
6030: CDT.RELATION_SHIP_ID,CDT.CUTOFF_TIME,CDT.TIMEZONE_ID,ISM.SHIP_METHOD
6031: FROM MTL_INTERORG_SHIP_METHODS ISM,CSP_CARRIER_DELIVERY_TIMES CDT
6032: WHERE ISM.FROM_ORGANIZATION_ID = from_org
6033: AND ISM.TO_ORGANIZATION_ID = to_org
6034: AND CDT.ORGANIZATION_ID = from_org
6035: AND CDT.SHIPPING_METHOD = ISM.SHIP_METHOD;