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 IC_WHSE_MST

Line 800: FROM ic_whse_mst

796: , x_loct_ctl OUT NOCOPY NUMBER) IS
797:
798: CURSOR get_whse_data IS
799: SELECT organization_id, subinventory_ind_flag, loct_ctl
800: FROM ic_whse_mst
801: WHERE whse_code = p_whse_code;
802:
803: BEGIN
804:

Line 896: FROM ic_whse_mst icw

892: -- Bug# 5569346
893: PROCEDURE CREATE_CONFIG_ROWS_FOR_WHSE(p_migration_run_id IN NUMBER, p_commit IN VARCHAR2) IS
894: CURSOR cur_whse_info IS
895: SELECT icw.whse_code, icw.orgn_code, icw.organization_id
896: FROM ic_whse_mst icw
897: WHERE ( icw.subinventory_ind_flag <> 'Y'
898: OR icw.subinventory_ind_flag IS NULL)
899: AND NOT EXISTS (SELECT organization_id
900: FROM gmd_quality_config

Line 1243: CURSOR get_whse_orgn (p_organization_id ic_whse_mst.organization_id%TYPE) IS

1239: /*=======================================
1240: Cursor to get whse orgn_code.
1241: =======================================*/
1242:
1243: CURSOR get_whse_orgn (p_organization_id ic_whse_mst.organization_id%TYPE) IS
1244: SELECT orgn_code
1245: FROM ic_whse_mst
1246: WHERE subinventory_ind_flag = 'Y'
1247: AND mtl_organization_id = p_organization_id;

Line 1245: FROM ic_whse_mst

1241: =======================================*/
1242:
1243: CURSOR get_whse_orgn (p_organization_id ic_whse_mst.organization_id%TYPE) IS
1244: SELECT orgn_code
1245: FROM ic_whse_mst
1246: WHERE subinventory_ind_flag = 'Y'
1247: AND mtl_organization_id = p_organization_id;
1248:
1249: l_orig_orgn_code ic_whse_mst.orgn_code%TYPE;

Line 1249: l_orig_orgn_code ic_whse_mst.orgn_code%TYPE;

1245: FROM ic_whse_mst
1246: WHERE subinventory_ind_flag = 'Y'
1247: AND mtl_organization_id = p_organization_id;
1248:
1249: l_orig_orgn_code ic_whse_mst.orgn_code%TYPE;
1250:
1251: /*=======================================
1252: Cursor to get config record.
1253: =======================================*/

Line 2254: -- Creates the Quality config rows for warehouse (ic_whse_mst) rows

2250:
2251: END; -- end of null subprogram
2252:
2253: -- Bug# 5569346
2254: -- Creates the Quality config rows for warehouse (ic_whse_mst) rows
2255: create_config_rows_for_whse(p_migration_run_id, p_commit);
2256:
2257: /*==============================================
2258: Log end of gmd_quality_config migration.

Line 2491: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;

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;
2495: ls_organization_id mtl_item_locations.organization_id%TYPE;

Line 2496: l_loct_ctl ic_whse_mst.loct_ctl%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;
2500: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;

Line 2497: l_store_loct_ctl ic_whse_mst.loct_ctl%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;
2500: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2501: l_store_subinv gmd_samples.storage_subinventory%TYPE;

Line 2502: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;

2498: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;
2499: l_storage_org_id gmd_samples.storage_organization_id%TYPE;
2500: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2501: l_store_subinv gmd_samples.storage_subinventory%TYPE;
2502: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2503: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
2504: l_lot_number gmd_samples.lot_number%TYPE;
2505: l_get_parent_only NUMBER := 0;
2506: l_failure_count NUMBER;

Line 2512: l_source_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;

2508: -- Bug# 5261810
2509: l_org_id NUMBER;
2510: l_material_detail_id NUMBER;
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;

Line 2513: l_source_loct_ctl ic_whse_mst.loct_ctl%TYPE;

2509: l_org_id NUMBER;
2510: l_material_detail_id NUMBER;
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;

Line 3964: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;

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;
3968: l_loct_ctl ic_whse_mst.loct_ctl%TYPE;

Line 3968: l_loct_ctl ic_whse_mst.loct_ctl%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;
3972: l_get_parent_only NUMBER := 0;

Line 3969: l_mon_loct_ctl ic_whse_mst.loct_ctl%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;
3972: l_get_parent_only NUMBER := 0;
3973: l_failure_count NUMBER;

Line 7230: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;

7226: FROM gmd_stability_studies_b
7227: WHERE migrated_ind IS NULL
7228: AND orgn_code IS NOT NULL;
7229:
7230: l_store_loct_ctl ic_whse_mst.loct_ctl%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;

Line 7231: l_splan_loct_ctl ic_whse_mst.loct_ctl%TYPE;

7227: WHERE migrated_ind IS NULL
7228: AND orgn_code IS NOT NULL;
7229:
7230: l_store_loct_ctl ic_whse_mst.loct_ctl%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;

Line 7232: l_hist_loct_ctl ic_whse_mst.loct_ctl%TYPE;

7228: AND orgn_code IS NOT NULL;
7229:
7230: l_store_loct_ctl ic_whse_mst.loct_ctl%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;

Line 7233: l_svar_loct_ctl ic_whse_mst.loct_ctl%TYPE;

7229:
7230: l_store_loct_ctl ic_whse_mst.loct_ctl%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;

Line 7255: l_plan_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;

7251: WHERE migrated_ind IS NULL
7252: AND storage_organization_id IS NULL;
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:

Line 7362: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;

7358: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;
7359: l_storage_location gmd_ss_variants.storage_location%TYPE;
7360: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;
7361: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;
7362: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7363: l_storage_locator_id gmd_ss_variants.storage_locator_id%TYPE;
7364:
7365: /*=========================================
7366: Cursor to get gmd_ss_storage_history.

Line 7382: l_hist_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;

7378: AND organization_id IS NULL;
7379:
7380: l_hist_org_id gmd_ss_storage_history.organization_id%TYPE;
7381: l_hist_subinventory gmd_ss_storage_history.subinventory%TYPE;
7382: l_hist_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7383: l_hist_locator_id gmd_ss_storage_history.locator_id%TYPE;
7384:
7385: l_text_code NUMBER;
7386: