DBA Data[Home] [Help]

APPS.GMD_QC_MIGRATE_TO_1151J dependencies on GMD_INVENTORY_SPEC_VRS

Line 3254: INSERT INTO gmd_inventory_spec_vrs

3250: l_sublot_no := null;
3251: ENd IF;
3252:
3253: /* Create an item spec validity rule */
3254: INSERT INTO gmd_inventory_spec_vrs
3255: (
3256: spec_vr_id,
3257: spec_id,
3258: orgn_code,

Line 6028: p_table_name => 'GMD_INVENTORY_SPEC_VRS',

6024: and SPEC_VR_STATUS = 700;
6025:
6026: GMA_MIGRATION.gma_insert_message (
6027: p_run_id => p_migration_id,
6028: p_table_name => 'GMD_INVENTORY_SPEC_VRS',
6029: p_DB_ERROR => '',
6030: p_param1 => 'Nulling out end date on Inventory vrs ',
6031: p_param2 => 'Where end date is SY$MAX_DATE ',
6032: p_param3 => '',

Line 6042: update gmd_inventory_spec_vrs

6038: p_position => '',
6039: p_base_message => '');
6040:
6041:
6042: update gmd_inventory_spec_vrs
6043: set end_date = NULL
6044: where trunc(end_date + 1) >= l_max_date
6045: and SPEC_VR_STATUS = 700;
6046: