APPS.GMD_QC_MIG12 dependencies on IC_LOCT_MST

Line 835: FROM ic_loct_mst

831: p_location IN VARCHAR2) RETURN NUMBER IS
832:
833: CURSOR get_locator_id IS
834: SELECT locator_id
835: FROM ic_loct_mst
836: WHERE whse_code = p_whse_code
837: AND location = p_location;
838:
839: l_locator_id ic_loct_mst.inventory_location_id%TYPE;

Line 839: l_locator_id ic_loct_mst.inventory_location_id%TYPE;

835: FROM ic_loct_mst
836: WHERE whse_code = p_whse_code
837: AND location = p_location;
838:
839: l_locator_id ic_loct_mst.inventory_location_id%TYPE;
840:
841: BEGIN
842:
843: OPEN get_locator_id;

Line 2492: l_locator_id ic_loct_mst.inventory_location_id%TYPE;

2488: l_organization_id gmd_samples.organization_id%TYPE;
2489: l_lab_organization_id gmd_samples.organization_id%TYPE;
2490: l_subinventory mtl_item_locations.subinventory_code%TYPE;
2491: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2492: l_locator_id ic_loct_mst.inventory_location_id%TYPE;
2493: l_subinv mtl_item_locations.subinventory_code%TYPE;
2494: lsub_organization_id mtl_item_locations.organization_id%TYPE;
2495: ls_organization_id mtl_item_locations.organization_id%TYPE;
2496: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;

Line 2515: l_source_locator_id ic_loct_mst.inventory_location_id%TYPE;

2511: l_source_org_id gmd_samples.organization_id%TYPE;
2512: l_source_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2513: l_source_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2514: l_source_subinv gmd_samples.source_subinventory%TYPE;
2515: l_source_locator_id ic_loct_mst.inventory_location_id%TYPE;
2516: l_source_subinv_loc mtl_item_locations.subinventory_code%TYPE;
2517: l_src_sub_organization_id mtl_item_locations.organization_id%TYPE;
2518:
2519:

Line 3965: l_locator_id ic_loct_mst.inventory_location_id%TYPE;

3961: l_organization_id gmd_samples.organization_id%TYPE;
3962: ls_organization_id gmd_samples.organization_id%TYPE;
3963: l_subinventory mtl_item_locations.subinventory_code%TYPE;
3964: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
3965: l_locator_id ic_loct_mst.inventory_location_id%TYPE;
3966: l_subinv mtl_item_locations.subinventory_code%TYPE;
3967: lsub_organization_id mtl_item_locations.organization_id%TYPE;
3968: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;
3969: l_mon_loct_ctl ic_whse_mst.loct_ctl%TYPE;

Line 7257: l_plan_locator_id ic_loct_mst.locator_id%TYPE;

7253:
7254: l_plan_org_id gmd_storage_plan_details.storage_organization_id%TYPE;
7255: l_plan_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
7256: l_plan_subinv gmd_storage_plan_details.storage_subinventory%TYPE;
7257: l_plan_locator_id ic_loct_mst.locator_id%TYPE;
7258:
7259:
7260:
7261: /*=====================================