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.CSP_PLAN_DETAILS_PKG dependencies on CSP_SUPERSEDE_ITEMS

Line 1826: from csp_supersede_items csi

1822: -- delete unfilled requirement for parts that are superseded
1823: delete from csp_plan_details cpd
1824: where (organization_id,inventory_item_id) in
1825: (select csi.organization_id,csi.inventory_item_id
1826: from csp_supersede_items csi
1827: where csi.inventory_item_id = cpd.inventory_item_id
1828: and csi.organization_id = cpd.organization_id
1829: and csi.sub_inventory_code = '-'
1830: and csi.item_supplied <> csi.inventory_item_id)

Line 3212: csp_supersede_items csi

3208: min(cpd.last_updated_by),
3209: min(cpd.last_update_date),
3210: min(cpd.last_update_login)
3211: from csp_plan_details cpd,
3212: csp_supersede_items csi
3213: where cpd.plan_detail_type in ('1200','1300','1400','2000')
3214: and cpd.organization_id = l_organization_id
3215: and cpd.inventory_item_id = nvl(l_inventory_item_id,cpd.inventory_item_id)
3216: and csi.organization_id = cpd.organization_id

Line 3226: from csp_supersede_items csi

3222: -- Delete recommendations for superseeded parts
3223: delete from csp_plan_details cpd
3224: where (organization_id,inventory_item_id) in
3225: (select csi.organization_id,csi.inventory_item_id
3226: from csp_supersede_items csi
3227: where csi.inventory_item_id = cpd.inventory_item_id
3228: and csi.organization_id = cpd.organization_id
3229: and csi.sub_inventory_code = '-'
3230: and csi.item_supplied <> csi.inventory_item_id)