DBA Data[Home] [Help]

APPS.CSP_SUPERSESSIONS_PVT dependencies on CSP_SEC_INVENTORIES

Line 829: from MTL_SUBINVENTORIES_ALL_V msa , CSP_SEC_INVENTORIES_V csi

825: and mri.RELATIONSHIP_TYPE_ID = 18;
826:
827: cursor get_usable_subinventories IS
828: /* select msa.SECONDARY_INVENTORY_NAME
829: from MTL_SUBINVENTORIES_ALL_V msa , CSP_SEC_INVENTORIES_V csi
830: where msa.organization_id = p_org_id
831: and csi.organization_id = msa.organization_id
832: and csi.SECONDARY_INVENTORY_NAME = msa.SECONDARY_INVENTORY_NAME
833: and csi.condition_type <> 'B';*/

Line 835: from mtl_secondary_inventories msa , CSP_SEC_INVENTORIES csi

831: and csi.organization_id = msa.organization_id
832: and csi.SECONDARY_INVENTORY_NAME = msa.SECONDARY_INVENTORY_NAME
833: and csi.condition_type <> 'B';*/
834: select msa.SECONDARY_INVENTORY_NAME
835: from mtl_secondary_inventories msa , CSP_SEC_INVENTORIES csi
836: where msa.organization_id = p_org_id
837: and csi.organization_id = msa.organization_id
838: and csi.SECONDARY_INVENTORY_NAME = msa.SECONDARY_INVENTORY_NAME
839: and csi.condition_type <> 'B';