eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CTO_DEACTIVATE_CONFIG_PK dependencies on BOM_CTO_MODEL_ORGS

Line 1765: FROM bom_cto_model_orgs

1761:
1762: BEGIN
1763: SELECT group_reference_id
1764: INTO l_grp_reference_id
1765: FROM bom_cto_model_orgs
1766: WHERE config_item_id = p_table(l_index).cfg_item_id
1767: AND rownum = 1;
1768: EXCEPTION
1769: WHEN no_data_found THEN

Line 1776: DELETE FROM bom_cto_model_orgs

1772:
1773: -- new fix
1774: --used grp_ref_id in where clause instead of cfg-item_id
1775: --as grp_ref_id has index on it
1776: DELETE FROM bom_cto_model_orgs
1777: WHERE group_reference_id = l_grp_reference_id;
1778:
1779:
1780: END IF;

Line 2583: bom_cto_model_orgs bcmo

2579: AND bcso.organization_id = p_org_id
2580: UNION ALL
2581: SELECT bcso.line_id line_id
2582: FROM bom_cto_src_orgs_b bcso,
2583: bom_cto_model_orgs bcmo
2584: WHERE bcso.group_reference_id IS NOT NULL
2585: AND bcso.group_reference_id = bcmo.group_reference_id
2586: AND bcso.config_item_id = p_inventory_item_id
2587: AND bcso.organization_id = p_org_id