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.GMD_QC_MIG12 dependencies on MTL_ITEM_LOCATIONS

Line 880: FROM mtl_item_locations

876: IS
877:
878: CURSOR get_subinv IS
879: SELECT subinventory_code, organization_id
880: FROM mtl_item_locations
881: WHERE inventory_location_id = p_locator_id;
882:
883:
884: BEGIN

Line 2490: l_subinventory mtl_item_locations.subinventory_code%TYPE;

2486: ==============================*/
2487:
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;

Line 2493: l_subinv mtl_item_locations.subinventory_code%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;
2497: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;

Line 2494: lsub_organization_id mtl_item_locations.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;
2497: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2498: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;

Line 2495: ls_organization_id mtl_item_locations.organization_id%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;
2497: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2498: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;
2499: l_storage_org_id gmd_samples.storage_organization_id%TYPE;

Line 2516: l_source_subinv_loc mtl_item_locations.subinventory_code%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:
2520: CURSOR get_item_data (v_item_id ic_item_mst.item_id%TYPE) IS

Line 2517: l_src_sub_organization_id mtl_item_locations.organization_id%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:
2520: CURSOR get_item_data (v_item_id ic_item_mst.item_id%TYPE) IS
2521: SELECT sublot_ctl

Line 3963: l_subinventory mtl_item_locations.subinventory_code%TYPE;

3959: ==============================*/
3960:
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;

Line 3966: l_subinv mtl_item_locations.subinventory_code%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;
3970: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;

Line 3967: lsub_organization_id mtl_item_locations.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;
3970: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
3971: l_lot_number gmd_samples.lot_number%TYPE;

Line 7235: l_subinv mtl_item_locations.subinventory_code%TYPE;

7231: l_splan_loct_ctl ic_whse_mst.loct_ctl%TYPE;
7232: l_hist_loct_ctl ic_whse_mst.loct_ctl%TYPE;
7233: l_svar_loct_ctl ic_whse_mst.loct_ctl%TYPE;
7234: l_inventory_item_id gmd_stability_studies_b.inventory_item_id%TYPE;
7235: l_subinv mtl_item_locations.subinventory_code%TYPE;
7236: lsub_organization_id mtl_item_locations.organization_id%TYPE;
7237: l_lot_orgn_code gmd_stability_studies_b.orgn_code%TYPE;
7238: l_stab_org_id gmd_stability_studies_b.organization_id%TYPE;
7239:

Line 7236: lsub_organization_id mtl_item_locations.organization_id%TYPE;

7232: l_hist_loct_ctl ic_whse_mst.loct_ctl%TYPE;
7233: l_svar_loct_ctl ic_whse_mst.loct_ctl%TYPE;
7234: l_inventory_item_id gmd_stability_studies_b.inventory_item_id%TYPE;
7235: l_subinv mtl_item_locations.subinventory_code%TYPE;
7236: lsub_organization_id mtl_item_locations.organization_id%TYPE;
7237: l_lot_orgn_code gmd_stability_studies_b.orgn_code%TYPE;
7238: l_stab_org_id gmd_stability_studies_b.organization_id%TYPE;
7239:
7240: