DBA Data[Home] [Help]

APPS.CSP_PART_SEARCH_PVT dependencies on CSP_SEC_INVENTORIES

Line 478: from csp_sec_inventories csi,

474: cpp.secondary_inventory,
475: csi.condition_type,
476: csi.owner_resource_type,
477: csi.owner_resource_id
478: from csp_sec_inventories csi,
479: csp_planning_parameters cpp,
480: hz_locations hl
481: where cpp.organization_id = csi.organization_id
482: and cpp.secondary_inventory = csi.secondary_inventory_name

Line 567: csp_sec_inventories csi

563: end
564: from
565: csp_required_parts_temp crpt,
566: cac_sr_object_capacity csoc,
567: csp_sec_inventories csi
568: where (cr.organization_id <> l_organization_id
569: or nvl(cr.secondary_inventory,'-1') <> l_subinventory_code)
570: and csi.organization_id = cr.organization_id
571: and csi.secondary_inventory_name = cr.secondary_inventory

Line 1675: from csp_sec_inventories

1671: and inventory_item_id = p_inventory_item_id;
1672:
1673: cursor c_defective_sub is
1674: select secondary_inventory_name
1675: from csp_sec_inventories
1676: where organization_id = p_organization_id
1677: and condition_type = 'B';
1678:
1679: -- bug 9724125