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 635: SELECT master_organization_id INTO l_mater_org_id FROM mtl_parameters

631: ---
632: IF p_bom_header_rec.transaction_type = Bom_Globals.G_OPR_CREATE AND
633: p_bom_head_unexp_rec.source_bill_sequence_id IS NULL
634: THEN
635: SELECT master_organization_id INTO l_mater_org_id FROM mtl_parameters
636: WHERE organization_id = p_bom_head_unexp_rec.organization_id;
637: IF (p_bom_head_unexp_rec.organization_id <> l_mater_org_id) THEN
638: Error_Handler.Add_Error_Token
639: ( p_message_name => 'BOM_PKG_HIERARCHY_IN_CHILD_ORG'

Line 1004: FROM mtl_parameters mp1, mtl_parameters mp2

1000: THEN
1001: BEGIN
1002: SELECT '1'
1003: INTO l_dummy
1004: FROM mtl_parameters mp1, mtl_parameters mp2
1005: WHERE mp1.organization_id = p_bom_head_unexp_rec.organization_id
1006: AND mp2.organization_id =
1007: DECODE(p_bom_header_rec.transaction_type, Bom_Globals.G_OPR_CREATE,
1008: p_bom_head_unexp_rec.common_organization_id,