APPS.JMF_SHIKYU_ALLOCATION_PVT dependencies on MTL_INTERORG_SHIP_METHODS

Line 819: l_ship_lead_time MTL_INTERORG_SHIP_METHODS.intransit_time%TYPE;

815: l_api_version CONSTANT NUMBER := 1.0;
816:
817: l_wip_job_start_date WIP_DISCRETE_JOBS.scheduled_start_date%TYPE;
818: l_wip_job_complete_date WIP_DISCRETE_JOBS.scheduled_completion_date%TYPE;
819: l_ship_lead_time MTL_INTERORG_SHIP_METHODS.intransit_time%TYPE;
820:
821: l_remaining_qty NUMBER;
822: l_tbl_index NUMBER;
823: l_out_tbl_index NUMBER;

Line 835: l_oem_organization_id mtl_interorg_ship_methods.from_organization_id%TYPE;

831:
832: g_no_wip_job_found_exc EXCEPTION;
833: g_no_ship_method_found_exc EXCEPTION;
834:
835: l_oem_organization_id mtl_interorg_ship_methods.from_organization_id%TYPE;
836: l_tp_organization_id mtl_interorg_ship_methods.to_organization_id%TYPE;
837: l_message VARCHAR(2000);
838: l_status_flag BOOLEAN;
839: l_tp_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

Line 836: l_tp_organization_id mtl_interorg_ship_methods.to_organization_id%TYPE;

832: g_no_wip_job_found_exc EXCEPTION;
833: g_no_ship_method_found_exc EXCEPTION;
834:
835: l_oem_organization_id mtl_interorg_ship_methods.from_organization_id%TYPE;
836: l_tp_organization_id mtl_interorg_ship_methods.to_organization_id%TYPE;
837: l_message VARCHAR(2000);
838: l_status_flag BOOLEAN;
839: l_tp_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;
840: l_oem_organization MTL_PARAMETERS.ORGANIZATION_CODE%TYPE;

Line 909: FROM MTL_INTERORG_SHIP_METHODS mism,

905: CURSOR c_ship_lead_time_cur IS
906: SELECT NVL(mism.intransit_time, 0)
907: , FROM_organization_id
908: , to_organization_id
909: FROM MTL_INTERORG_SHIP_METHODS mism,
910: JMF_SUBCONTRACT_ORDERS jso
911: WHERE mism.from_organization_id = jso.oem_organization_id
912: AND mism.to_organization_id = jso.tp_organization_id
913: AND mism.default_flag = 1