67: -- the original kit.
68:
69: CURSOR cur_get_collateral_items(p_collateral_id NUMBER) IS
70: SELECT delv.INVENTORY_ITEM_ID
71: FROM ams_deliverables_all_b delv
72: WHERE delv.deliverable_id = p_collateral_id
73: UNION
74: SELECT delv.INVENTORY_ITEM_ID
75: FROM ams_deliverables_all_b delv,
71: FROM ams_deliverables_all_b delv
72: WHERE delv.deliverable_id = p_collateral_id
73: UNION
74: SELECT delv.INVENTORY_ITEM_ID
75: FROM ams_deliverables_all_b delv,
76: mtl_system_items_b msi
77: WHERE delv.deliverable_id in (select deliverable_kit_part_id
78: FROM ams_deliv_kit_items
79: WHERE deliverable_kit_id = p_collateral_id)