DBA Data[Home] [Help]

APPS.WSM_WLT_VALIDATE_PVT dependencies on BOM_ALTERNATE_DESIGNATORS

Line 409: bom_alternate_designators bad

405: bom.common_bill_sequence_id
406: INTO x_bom_seq_id,
407: p_common_bom_seq_id --x_common_bom_seq_id --VJ: Changed
408: FROM bom_bill_of_materials bom,
409: bom_alternate_designators bad
410: WHERE ((bom.alternate_bom_designator is null and
411: bad.alternate_designator_code is null and
412: bad.organization_id = -1) or
413: (bom.alternate_bom_designator

Line 419: -- ST : Bug fix 5107339 : Commented out the validation on bom_alternate_designators.disable_date

415: bom.organization_id = bad.organization_id))
416: AND bom.alternate_bom_designator = p_alt_bom
417: AND bom.assembly_item_id = l_bom_item_id
418: AND bom.organization_id = p_org_id;
419: -- ST : Bug fix 5107339 : Commented out the validation on bom_alternate_designators.disable_date
420: -- AND trunc(nvl(bad.disable_date, sysdate + 1)) > trunc(sysdate);
421: EXCEPTION
422: WHEN no_data_found then
423: IF g_log_level_error >= l_log_level OR