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 792: FROM ic_whse_mst

788: , x_loct_ctl OUT NOCOPY NUMBER) IS
789:
790: CURSOR get_whse_data IS
791: SELECT organization_id, subinventory_ind_flag, loct_ctl
792: FROM ic_whse_mst
793: WHERE whse_code = p_whse_code;
794:
795: BEGIN
796:

Line 888: FROM ic_whse_mst icw

884: -- Bug# 5569346
885: PROCEDURE CREATE_CONFIG_ROWS_FOR_WHSE(p_migration_run_id IN NUMBER, p_commit IN VARCHAR2) IS
886: CURSOR cur_whse_info IS
887: SELECT icw.whse_code, icw.orgn_code, icw.organization_id
888: FROM ic_whse_mst icw
889: WHERE ( icw.subinventory_ind_flag <> 'Y'
890: OR icw.subinventory_ind_flag IS NULL)
891: AND NOT EXISTS (SELECT organization_id
892: FROM gmd_quality_config

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

1231: /*=======================================
1232: Cursor to get whse orgn_code.
1233: =======================================*/
1234:
1235: CURSOR get_whse_orgn (p_organization_id ic_whse_mst.organization_id%TYPE) IS
1236: SELECT orgn_code
1237: FROM ic_whse_mst
1238: WHERE subinventory_ind_flag = 'Y'
1239: AND mtl_organization_id = p_organization_id;

Line 1237: FROM ic_whse_mst

1233: =======================================*/
1234:
1235: CURSOR get_whse_orgn (p_organization_id ic_whse_mst.organization_id%TYPE) IS
1236: SELECT orgn_code
1237: FROM ic_whse_mst
1238: WHERE subinventory_ind_flag = 'Y'
1239: AND mtl_organization_id = p_organization_id;
1240:
1241: l_orig_orgn_code ic_whse_mst.orgn_code%TYPE;

Line 1241: l_orig_orgn_code ic_whse_mst.orgn_code%TYPE;

1237: FROM ic_whse_mst
1238: WHERE subinventory_ind_flag = 'Y'
1239: AND mtl_organization_id = p_organization_id;
1240:
1241: l_orig_orgn_code ic_whse_mst.orgn_code%TYPE;
1242:
1243: /*=======================================
1244: Cursor to get config record.
1245: =======================================*/

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

2242:
2243: END; -- end of null subprogram
2244:
2245: -- Bug# 5569346
2246: -- Creates the Quality config rows for warehouse (ic_whse_mst) rows
2247: create_config_rows_for_whse(p_migration_run_id, p_commit);
2248:
2249: /*==============================================
2250: Log end of gmd_quality_config migration.

Line 2472: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;

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

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

Line 2478: l_store_loct_ctl ic_whse_mst.loct_ctl%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;
2481: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2482: l_store_subinv gmd_samples.storage_subinventory%TYPE;

Line 2483: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;

2479: l_inventory_item_id gmd_samples.inventory_item_id%TYPE;
2480: l_storage_org_id gmd_samples.storage_organization_id%TYPE;
2481: l_storage_locator_id gmd_samples.storage_locator_id%TYPE;
2482: l_store_subinv gmd_samples.storage_subinventory%TYPE;
2483: l_store_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;
2484: l_parent_lot_number gmd_samples.parent_lot_number%TYPE;
2485: l_lot_number gmd_samples.lot_number%TYPE;
2486: l_get_parent_only NUMBER := 0;
2487: l_failure_count NUMBER;

Line 2493: l_source_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;

2489: -- Bug# 5261810
2490: l_org_id NUMBER;
2491: l_material_detail_id NUMBER;
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;

Line 2494: l_source_loct_ctl ic_whse_mst.loct_ctl%TYPE;

2490: l_org_id NUMBER;
2491: l_material_detail_id NUMBER;
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;

Line 3695: l_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;

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

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

Line 3700: l_mon_loct_ctl ic_whse_mst.loct_ctl%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;
3703: l_get_parent_only NUMBER := 0;
3704: l_failure_count NUMBER;

Line 6961: l_store_loct_ctl ic_whse_mst.loct_ctl%TYPE;

6957: FROM gmd_stability_studies_b
6958: WHERE migrated_ind IS NULL
6959: AND orgn_code IS NOT NULL;
6960:
6961: l_store_loct_ctl ic_whse_mst.loct_ctl%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;

Line 6962: l_splan_loct_ctl ic_whse_mst.loct_ctl%TYPE;

6958: WHERE migrated_ind IS NULL
6959: AND orgn_code IS NOT NULL;
6960:
6961: l_store_loct_ctl ic_whse_mst.loct_ctl%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;

Line 6963: l_hist_loct_ctl ic_whse_mst.loct_ctl%TYPE;

6959: AND orgn_code IS NOT NULL;
6960:
6961: l_store_loct_ctl ic_whse_mst.loct_ctl%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;

Line 6964: l_svar_loct_ctl ic_whse_mst.loct_ctl%TYPE;

6960:
6961: l_store_loct_ctl ic_whse_mst.loct_ctl%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;

Line 6986: l_plan_subinv_ind ic_whse_mst.subinventory_ind_flag%TYPE;

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

Line 7093: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;

7089: l_storage_whse_code gmd_ss_variants.storage_whse_code%TYPE;
7090: l_storage_location gmd_ss_variants.storage_location%TYPE;
7091: l_storage_organization_id gmd_ss_variants.storage_organization_id%TYPE;
7092: l_storage_subinventory gmd_ss_variants.storage_subinventory%TYPE;
7093: l_storage_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7094: l_storage_locator_id gmd_ss_variants.storage_locator_id%TYPE;
7095:
7096: /*=========================================
7097: Cursor to get gmd_ss_storage_history.

Line 7113: l_hist_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;

7109: AND organization_id IS NULL;
7110:
7111: l_hist_org_id gmd_ss_storage_history.organization_id%TYPE;
7112: l_hist_subinventory gmd_ss_storage_history.subinventory%TYPE;
7113: l_hist_subinvind ic_whse_mst.subinventory_ind_flag%TYPE;
7114: l_hist_locator_id gmd_ss_storage_history.locator_id%TYPE;
7115:
7116: l_text_code NUMBER;
7117: