[Home] [Help]
837: SELECT ORGANIZATION_ID INTO nOrg_ID FROM CZ_EXV_ORGANIZATIONS
838: WHERE ORGANIZATION_CODE = sOrg_ID;
839:
840: SELECT inventory_item_id INTO nTop_ID
841: FROM cz_exv_mtl_system_items
842: WHERE bom_item_type = 1
843: AND organization_id = nOrg_ID
844: AND concatenated_segments = sTop_ID
845: AND rownum = 1;
861: sOrg_ID IN VARCHAR2,dsOrg_ID IN VARCHAR2,
862: sFrom IN VARCHAR2,sTo IN VARCHAR,
863: COPY_CHILD_MODELS IN VARCHAR2 DEFAULT '0') IS
864: CURSOR C_GETMODELS(Org_ID NUMBER) IS
865: SELECT A.ASSEMBLY_ITEM_ID FROM CZ_EXV_BILL_OF_MATERIALS A,CZ_EXV_MTL_SYSTEM_ITEMS B
866: WHERE A.ASSEMBLY_ITEM_ID=B.INVENTORY_ITEM_ID
867: AND A.ORGANIZATION_ID=B.ORGANIZATION_ID
868: AND B.BOM_ITEM_TYPE=1
869: AND A.ORGANIZATION_ID=Org_ID
928: ------------------------------------------------------------------------------------------
929:
930: -- Bug10011026 This procedure was introduced for Sun implementation where new Concurrent Program
931: -- was introduced with same (segment1) value for sFrom and sTo parameters and cursor C_GETMODELS
932: -- in original proc was changed to go against only cz_exv_mtl_system_items for performance improvement
933: PROCEDURE PopulateSingleModel_cp(errbuf OUT NOCOPY VARCHAR2,retcode OUT NOCOPY NUMBER,
934: sOrg_ID IN VARCHAR2,dsOrg_ID IN VARCHAR2,
935: sFrom IN VARCHAR2,sTo IN VARCHAR,
936: COPY_CHILD_MODELS IN VARCHAR2 DEFAULT '0') IS
934: sOrg_ID IN VARCHAR2,dsOrg_ID IN VARCHAR2,
935: sFrom IN VARCHAR2,sTo IN VARCHAR,
936: COPY_CHILD_MODELS IN VARCHAR2 DEFAULT '0') IS
937: CURSOR C_GETMODELS(Org_ID NUMBER) IS
938: SELECT B.INVENTORY_ITEM_ID FROM CZ_EXV_MTL_SYSTEM_ITEMS B
939: WHERE B.BOM_ITEM_TYPE=1
940: AND B.ORGANIZATION_ID=Org_ID
941: AND B.CONCATENATED_SEGMENTS = sFrom ;
942: