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 872: FROM mtl_item_locations

868: IS
869:
870: CURSOR get_subinv IS
871: SELECT subinventory_code, organization_id
872: FROM mtl_item_locations
873: WHERE inventory_location_id = p_locator_id;
874:
875:
876: BEGIN

Line 2471: l_subinventory mtl_item_locations.subinventory_code%TYPE;

2467: ==============================*/
2468:
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;

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

Line 2475: lsub_organization_id mtl_item_locations.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;
2478: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2479: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;

Line 2476: ls_organization_id mtl_item_locations.organization_id%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;
2478: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;
2479: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;
2480: l_storage_org_id gmd_samples.storage_organization_id%TYPE;

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

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

Line 3694: l_subinventory mtl_item_locations.subinventory_code%TYPE;

3690: ==============================*/
3691:
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;

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

Line 3698: lsub_organization_id mtl_item_locations.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;
3701: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
3702: l_lot_number gmd_samples.lot_number%TYPE;

Line 6966: l_subinv mtl_item_locations.subinventory_code%TYPE;

6962: l_splan_loct_ctl ic_whse_mst.loct_ctl%TYPE;
6963: l_hist_loct_ctl ic_whse_mst.loct_ctl%TYPE;
6964: l_svar_loct_ctl ic_whse_mst.loct_ctl%TYPE;
6965: l_inventory_item_id gmd_stability_studies_b.inventory_item_id%TYPE;
6966: l_subinv mtl_item_locations.subinventory_code%TYPE;
6967: lsub_organization_id mtl_item_locations.organization_id%TYPE;
6968: l_lot_orgn_code gmd_stability_studies_b.orgn_code%TYPE;
6969: l_stab_org_id gmd_stability_studies_b.organization_id%TYPE;
6970:

Line 6967: lsub_organization_id mtl_item_locations.organization_id%TYPE;

6963: l_hist_loct_ctl ic_whse_mst.loct_ctl%TYPE;
6964: l_svar_loct_ctl ic_whse_mst.loct_ctl%TYPE;
6965: l_inventory_item_id gmd_stability_studies_b.inventory_item_id%TYPE;
6966: l_subinv mtl_item_locations.subinventory_code%TYPE;
6967: lsub_organization_id mtl_item_locations.organization_id%TYPE;
6968: l_lot_orgn_code gmd_stability_studies_b.orgn_code%TYPE;
6969: l_stab_org_id gmd_stability_studies_b.organization_id%TYPE;
6970:
6971: