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.CZ_IMP_IM_KRS dependencies on CZ_IMP_ITEM_TYPE_PROPERTY

Line 780: FROM CZ_IMP_ITEM_TYPE_PROPERTY WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, 2,ROWID;

776: CURSOR c_imp_itemtypeprop(x_usesurr_itemtype PLS_INTEGER,
777: x_usesurr_property PLS_INTEGER) IS
778: SELECT DECODE(x_usesurr_itemtype,0,FSK_ITEMTYPE_1_1,1,FSK_ITEMTYPE_1_EXT),
779: DECODE(x_usesurr_property,0,FSK_PROPERTY_2_1,1,FSK_PROPERTY_2_EXT), ROWID
780: FROM CZ_IMP_ITEM_TYPE_PROPERTY WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, 2,ROWID;
781: /* cursor's data found indicators */
782: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

Line 782: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;

778: SELECT DECODE(x_usesurr_itemtype,0,FSK_ITEMTYPE_1_1,1,FSK_ITEMTYPE_1_EXT),
779: DECODE(x_usesurr_property,0,FSK_PROPERTY_2_1,1,FSK_PROPERTY_2_EXT), ROWID
780: FROM CZ_IMP_ITEM_TYPE_PROPERTY WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, 2,ROWID;
781: /* cursor's data found indicators */
782: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

Line 783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;

779: DECODE(x_usesurr_property,0,FSK_PROPERTY_2_1,1,FSK_PROPERTY_2_EXT), ROWID
780: FROM CZ_IMP_ITEM_TYPE_PROPERTY WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, 2,ROWID;
781: /* cursor's data found indicators */
782: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

Line 784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

780: FROM CZ_IMP_ITEM_TYPE_PROPERTY WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID ORDER BY 1, 2,ROWID;
781: /* cursor's data found indicators */
782: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;

Line 785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;

781: /* cursor's data found indicators */
782: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;

Line 786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

782: nOnlItemTypeId CZ_IMP_ITEM_TYPE_PROPERTY.ITEM_TYPE_ID%TYPE;
783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
790: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;

Line 787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;

783: nOnlPropertyId CZ_IMP_ITEM_TYPE_PROPERTY.PROPERTY_ID%TYPE;
784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
790: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;
791: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;

Line 788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;

784: sFSKITEMTYPE CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
790: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;
791: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;
792: /* Column Vars */

Line 789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;

785: sFSKPROPERTY CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
790: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;
791: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;
792: /* Column Vars */
793: x_imp_itemtypeprop_f BOOLEAN:=FALSE;

Line 790: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;

786: sLastFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
790: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;
791: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;
792: /* Column Vars */
793: x_imp_itemtypeprop_f BOOLEAN:=FALSE;
794: x_onl_itemtypeprop_f BOOLEAN:=FALSE;

Line 791: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;

787: sThisFSK1 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_ITEMTYPE_1_1%TYPE;
788: sLastFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
789: sThisFSK2 CZ_IMP_ITEM_TYPE_PROPERTY.FSK_PROPERTY_2_1%TYPE;
790: sRecStatus CZ_IMP_ITEM_TYPE_PROPERTY.REC_STATUS%TYPE;
791: sDisposition CZ_IMP_ITEM_TYPE_PROPERTY.DISPOSITION%TYPE;
792: /* Column Vars */
793: x_imp_itemtypeprop_f BOOLEAN:=FALSE;
794: x_onl_itemtypeprop_f BOOLEAN:=FALSE;
795: x_onl_itemtype_itemtypeid_f BOOLEAN:=FALSE;

Line 915: UPDATE CZ_IMP_ITEM_TYPE_PROPERTY SET

911: END;
912: END IF;
913: END;
914: END IF;
915: UPDATE CZ_IMP_ITEM_TYPE_PROPERTY SET
916: ITEM_TYPE_ID=DECODE(sDISPOSITION,'R',ITEM_TYPE_ID,nOnlItemTypeId),
917: PROPERTY_ID=DECODE(sDISPOSITION,'R',PROPERTY_ID,nOnlPropertyId ),
918: DISPOSITION=sDisposition, REC_STATUS=sRecStatus
919: WHERE ROWID = thisRowId;

Line 939: AND PROPERTY_ID NOT IN (SELECT PROPERTY_ID FROM CZ_IMP_ITEM_TYPE_PROPERTY

935: SET DELETED_FLAG = '1'
936: WHERE ITEM_TYPE_ID IN (SELECT ITEM_TYPE_ID FROM CZ_IMP_ITEM_TYPE
937: WHERE RUN_ID = inRUN_ID
938: AND DELETED_FLAG = '0')
939: AND PROPERTY_ID NOT IN (SELECT PROPERTY_ID FROM CZ_IMP_ITEM_TYPE_PROPERTY
940: WHERE RUN_ID = inRUN_ID
941: AND ITEM_TYPE_ID = CZ_ITEM_TYPE_PROPERTIES.ITEM_TYPE_ID
942: AND DELETED_FLAG = '0')
943: AND PROPERTY_ID IN (SELECT PROPERTY_ID FROM CZ_PROPERTIES