DBA Data[Home] [Help]

APPS.INV_OPM_LOT_MIGRATION dependencies on GMI_MIGRATION_PARAMETERS

Line 210: l_field_name := 'GMI Migration Parameters';

206: BEGIN
207: -- Get lot numbers for discrete
208: l_lot_status := p_lot_status;
209: IF (x_lot_number is NULL) THEN
210: l_field_name := 'GMI Migration Parameters';
211: l_field_value := NULL;
212: SELECT l_opm_lot.lot_no || DECODE (l_opm_lot.sublot_no, NULL, NULL,
213: (SELECT lot_sublot_delimiter FROM gmi_migration_parameters)) ||
214: l_opm_lot.sublot_no,

Line 213: (SELECT lot_sublot_delimiter FROM gmi_migration_parameters)) ||

209: IF (x_lot_number is NULL) THEN
210: l_field_name := 'GMI Migration Parameters';
211: l_field_value := NULL;
212: SELECT l_opm_lot.lot_no || DECODE (l_opm_lot.sublot_no, NULL, NULL,
213: (SELECT lot_sublot_delimiter FROM gmi_migration_parameters)) ||
214: l_opm_lot.sublot_no,
215: DECODE(sublot_ctl, 1, DECODE(l_opm_lot.sublot_no, NULL, NULL,
216: l_opm_lot.lot_no)),
217: status_ctl, lot_status