DBA Data[Home] [Help]

APPS.BOM_VALIDATE_BOM_HEADER dependencies on MTL_PARAMETERS

Line 204: FROM mtl_parameters

200: AND organization_id = p_organization_id;
201:
202: SELECT process_enabled_flag
203: INTO l_OPM_org
204: FROM mtl_parameters
205: WHERE organization_id = p_organization_id;
206:
207: --
208: -- If user is trying to update an Engineering Item from BOM

Line 598: SELECT master_organization_id INTO l_mater_org_id FROM mtl_parameters

594: ---
595: IF p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND
596: p_bom_head_unexp_rec.source_bill_sequence_id IS NULL
597: THEN
598: SELECT master_organization_id INTO l_mater_org_id FROM mtl_parameters
599: WHERE organization_id = p_bom_head_unexp_rec.organization_id;
600: IF (p_bom_head_unexp_rec.organization_id <> l_mater_org_id) THEN
601: Error_Handler.Add_Error_Token
602: ( p_message_name => 'BOM_PKG_HIERARCHY_IN_CHILD_ORG'

Line 963: FROM mtl_parameters mp1, mtl_parameters mp2

959: THEN
960: BEGIN
961: SELECT '1'
962: INTO l_dummy
963: FROM mtl_parameters mp1, mtl_parameters mp2
964: WHERE mp1.organization_id = p_bom_head_unexp_rec.organization_id
965: AND mp2.organization_id =
966: DECODE(p_bom_header_rec.transaction_type, Bom_Globals.G_OPR_CREATE,
967: p_bom_head_unexp_rec.common_organization_id,