APPS.GMD_QC_MIG12 dependencies on IC_LOCT_MST

Line 827: FROM ic_loct_mst

823: p_location IN VARCHAR2) RETURN NUMBER IS
824:
825: CURSOR get_locator_id IS
826: SELECT locator_id
827: FROM ic_loct_mst
828: WHERE whse_code = p_whse_code
829: AND location = p_location;
830:
831: l_locator_id ic_loct_mst.inventory_location_id%TYPE;

Line 831: l_locator_id ic_loct_mst.inventory_location_id%TYPE;

827: FROM ic_loct_mst
828: WHERE whse_code = p_whse_code
829: AND location = p_location;
830:
831: l_locator_id ic_loct_mst.inventory_location_id%TYPE;
832:
833: BEGIN
834:
835: OPEN get_locator_id;

Line 2473: l_locator_id ic_loct_mst.inventory_location_id%TYPE;

2469: l_organization_id gmd_samples.organization_id%TYPE;
2470: l_lab_organization_id gmd_samples.organization_id%TYPE;
2471: l_subinventory mtl_item_locations.subinventory_code%TYPE;
2472: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2473: l_locator_id ic_loct_mst.inventory_location_id%TYPE;
2474: l_subinv mtl_item_locations.subinventory_code%TYPE;
2475: lsub_organization_id mtl_item_locations.organization_id%TYPE;
2476: ls_organization_id mtl_item_locations.organization_id%TYPE;
2477: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;

Line 2496: l_source_locator_id ic_loct_mst.inventory_location_id%TYPE;

2492: l_source_org_id gmd_samples.organization_id%TYPE;
2493: l_source_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2494: l_source_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2495: l_source_subinv gmd_samples.source_subinventory%TYPE;
2496: l_source_locator_id ic_loct_mst.inventory_location_id%TYPE;
2497: l_source_subinv_loc mtl_item_locations.subinventory_code%TYPE;
2498: l_src_sub_organization_id mtl_item_locations.organization_id%TYPE;
2499:
2500:

Line 3696: l_locator_id ic_loct_mst.inventory_location_id%TYPE;

3692: l_organization_id gmd_samples.organization_id%TYPE;
3693: ls_organization_id gmd_samples.organization_id%TYPE;
3694: l_subinventory mtl_item_locations.subinventory_code%TYPE;
3695: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
3696: l_locator_id ic_loct_mst.inventory_location_id%TYPE;
3697: l_subinv mtl_item_locations.subinventory_code%TYPE;
3698: lsub_organization_id mtl_item_locations.organization_id%TYPE;
3699: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
3700: l_mon_loct_ctl ic_whse_mst.loct_ctl%TYPE;

Line 6988: l_plan_locator_id ic_loct_mst.locator_id%TYPE;

6984:
6985: l_plan_org_id gmd_storage_plan_details.storage_organization_id%TYPE;
6986: l_plan_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
6987: l_plan_subinv gmd_storage_plan_details.storage_subinventory%TYPE;
6988: l_plan_locator_id ic_loct_mst.locator_id%TYPE;
6989:
6990:
6991:
6992: /*=====================================