DBA Data[Home] [Help]

APPS.BOMPXINQ dependencies on BOM_PARAMETERS

Line 149: FROM BOM_PARAMETERS

145: */
146:
147: SELECT max(MAXIMUM_BOM_LEVEL)
148: INTO max_level
149: FROM BOM_PARAMETERS
150: WHERE (org_id = -1
151: or
152: (org_id <> -1 and ORGANIZATION_ID = org_id)
153: );

Line 863: FROM BOM_PARAMETERS

859: RAISE cost_type;
860: END;
861: --Get the maximum level for explosion is allowed for the Organization
862: SELECT MAXIMUM_BOM_LEVEL INTO max_level
863: FROM BOM_PARAMETERS
864: WHERE ORGANIZATION_ID = t_org_code_list(I);
865:
866: SELECT bom_explosion_temp_s.nextval
867: INTO l_group_id from dual;