APPS.BOM_DELETE_GROUPS_API dependencies on MTL_PARAMETERS

Line 376: FROM BOM_DELETE_ENTITIES BDE, MTL_PARAMETERS MP

372: DELETE_ENTITY_SEQUENCE_ID delete_entity_seq_id,
373: MP.ORGANIZATION_CODE organization_code,
374: BDE.ITEM_CONCAT_SEGMENTS item_name, --bug:6193035 Removed substrb
375: BDE.ITEM_DESCRIPTION description
376: FROM BOM_DELETE_ENTITIES BDE, MTL_PARAMETERS MP
377: WHERE DELETE_GROUP_SEQUENCE_ID = p_group_id
378: AND DELETE_STATUS_TYPE in (1,2, decode(process_errored_rows, 'Y', 3, 1))
379: AND BDE.ORGANIZATION_ID = MP.ORGANIZATION_ID
380: ORDER BY decode(MP.MASTER_ORGANIZATION_ID,

Line 403: MTL_PARAMETERS MP

399: A.ITEM_CONCAT_SEGMENTS item_name,
400: B.COMPONENT_CONCAT_SEGMENTS comp_name,
401: B.description description
402: FROM BOM_DELETE_ENTITIES A, BOM_DELETE_SUB_ENTITIES B,
403: MTL_PARAMETERS MP
404: WHERE A.DELETE_GROUP_SEQUENCE_ID = p_group_id
405: AND B.DELETE_STATUS_TYPE in (1,2,3)
406: AND A.DELETE_ENTITY_SEQUENCE_ID =
407: B.DELETE_ENTITY_SEQUENCE_ID

Line 1776: FROM MTL_PARAMETERS

1772: p_object_name => 'ICX_CAT_POPULATE_MI_GRP') = 'Y') THEN
1773:
1774: SELECT DECODE(master_organization_id, p_org_id, 'Y', 'N'), organization_code
1775: INTO l_master_org_flag, l_org_code
1776: FROM MTL_PARAMETERS
1777: WHERE organization_id = p_org_id;
1778:
1779: stmt_num := 2;
1780: