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_MASTER

Line 21: FROM CZ_IMP_ITEM_MASTER

17: CURSOR c_imp_itemmaster(x_usesurr_itemtype pls_integer) IS
18: SELECT ORIG_SYS_REF, SRC_APPLICATION_ID, SRC_TYPE_CODE, ITEM_ID,ITEM_TYPE_ID,DESC_TEXT,REF_PART_NBR,QUOTEABLE_FLAG,PRIMARY_UOM_CODE,
19: LEAD_TIME,ITEM_STATUS,DELETED_FLAG,DECIMAL_QTY_FLAG,
20: DECODE(x_usesurr_itemtype,0,FSK_ITEMTYPE_1_1,1,FSK_ITEMTYPE_1_EXT), ROWID
21: FROM CZ_IMP_ITEM_MASTER
22: WHERE REC_STATUS IS NULL AND RUN_ID=inRUN_ID
23: ORDER BY 1,2,ROWID;
24:
25: v_settings_id VARCHAR2(40);

Line 44: nOnlItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;

40: x_onl_itemmaster_itemid_f BOOLEAN:=FALSE;
41: x_onl_default_itemtypeid_f BOOLEAN:=FALSE;
42: x_error BOOLEAN:=FALSE;
43: sDfltItemTypeId CZ_DB_SETTINGS.VALUE%TYPE;
44: nOnlItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
45: nOnlItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
46: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
47: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
48: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;

Line 45: nOnlItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;

41: x_onl_default_itemtypeid_f BOOLEAN:=FALSE;
42: x_error BOOLEAN:=FALSE;
43: sDfltItemTypeId CZ_DB_SETTINGS.VALUE%TYPE;
44: nOnlItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
45: nOnlItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
46: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
47: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
48: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
49: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;

Line 46: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;

42: x_error BOOLEAN:=FALSE;
43: sDfltItemTypeId CZ_DB_SETTINGS.VALUE%TYPE;
44: nOnlItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
45: nOnlItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
46: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
47: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
48: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
49: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
50: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;

Line 47: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;

43: sDfltItemTypeId CZ_DB_SETTINGS.VALUE%TYPE;
44: nOnlItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
45: nOnlItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
46: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
47: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
48: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
49: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
50: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
51: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;

Line 48: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;

44: nOnlItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
45: nOnlItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
46: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
47: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
48: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
49: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
50: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
51: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;
52: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;

Line 49: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;

45: nOnlItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
46: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
47: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
48: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
49: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
50: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
51: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;
52: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;
53: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;

Line 50: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;

46: nDfltItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
47: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
48: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
49: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
50: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
51: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;
52: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;
53: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;
54: nImpItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;

Line 51: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;

47: sImpOrigSysRef CZ_IMP_ITEM_MASTER.ORIG_SYS_REF%TYPE;
48: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
49: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
50: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
51: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;
52: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;
53: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;
54: nImpItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
55: nImpItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;

Line 52: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;

48: sFSKITEMTYPE CZ_IMP_ITEM_MASTER.FSK_ITEMTYPE_1_1%TYPE;
49: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
50: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
51: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;
52: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;
53: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;
54: nImpItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
55: nImpItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
56: nOnlItemTypeIdIB CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;

Line 53: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;

49: sLastFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
50: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
51: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;
52: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;
53: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;
54: nImpItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
55: nImpItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
56: nOnlItemTypeIdIB CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
57: nImpDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;

Line 54: nImpItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;

50: sThisFSK CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
51: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;
52: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;
53: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;
54: nImpItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
55: nImpItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
56: nOnlItemTypeIdIB CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
57: nImpDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
58: nOnlDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;

Line 55: nImpItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;

51: sRecStatus CZ_IMP_ITEM_MASTER.REC_STATUS%TYPE;
52: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;
53: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;
54: nImpItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
55: nImpItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
56: nOnlItemTypeIdIB CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
57: nImpDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
58: nOnlDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
59: nImpRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;

Line 56: nOnlItemTypeIdIB CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;

52: sDisposition CZ_IMP_ITEM_MASTER.DISPOSITION%TYPE;
53: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;
54: nImpItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
55: nImpItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
56: nOnlItemTypeIdIB CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
57: nImpDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
58: nOnlDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
59: nImpRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
60: nOnlRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;

Line 57: nImpDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;

53: nImpSrcApplicationId CZ_IMP_ITEM_MASTER.SRC_APPLICATION_ID%TYPE;
54: nImpItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
55: nImpItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
56: nOnlItemTypeIdIB CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
57: nImpDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
58: nOnlDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
59: nImpRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
60: nOnlRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
61: nImpQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;

Line 58: nOnlDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;

54: nImpItemId CZ_IMP_ITEM_MASTER.ITEM_ID%TYPE;
55: nImpItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
56: nOnlItemTypeIdIB CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
57: nImpDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
58: nOnlDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
59: nImpRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
60: nOnlRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
61: nImpQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
62: nOnlQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;

Line 59: nImpRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;

55: nImpItemTypeId CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
56: nOnlItemTypeIdIB CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
57: nImpDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
58: nOnlDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
59: nImpRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
60: nOnlRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
61: nImpQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
62: nOnlQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
63: nImpPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;

Line 60: nOnlRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;

56: nOnlItemTypeIdIB CZ_IMP_ITEM_MASTER.ITEM_TYPE_ID%TYPE;
57: nImpDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
58: nOnlDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
59: nImpRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
60: nOnlRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
61: nImpQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
62: nOnlQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
63: nImpPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
64: nOnlPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;

Line 61: nImpQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;

57: nImpDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
58: nOnlDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
59: nImpRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
60: nOnlRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
61: nImpQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
62: nOnlQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
63: nImpPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
64: nOnlPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
65: nImpLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;

Line 62: nOnlQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;

58: nOnlDescText CZ_IMP_ITEM_MASTER.DESC_TEXT%TYPE;
59: nImpRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
60: nOnlRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
61: nImpQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
62: nOnlQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
63: nImpPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
64: nOnlPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
65: nImpLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
66: nOnlLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;

Line 63: nImpPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;

59: nImpRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
60: nOnlRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
61: nImpQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
62: nOnlQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
63: nImpPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
64: nOnlPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
65: nImpLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
66: nOnlLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
67: nImpItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;

Line 64: nOnlPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;

60: nOnlRefPartNbr CZ_IMP_ITEM_MASTER.REF_PART_NBR%TYPE;
61: nImpQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
62: nOnlQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
63: nImpPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
64: nOnlPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
65: nImpLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
66: nOnlLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
67: nImpItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
68: nOnlItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;

Line 65: nImpLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;

61: nImpQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
62: nOnlQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
63: nImpPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
64: nOnlPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
65: nImpLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
66: nOnlLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
67: nImpItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
68: nOnlItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
69: nImpDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;

Line 66: nOnlLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;

62: nOnlQuoFlag CZ_IMP_ITEM_MASTER.QUOTEABLE_FLAG%TYPE;
63: nImpPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
64: nOnlPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
65: nImpLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
66: nOnlLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
67: nImpItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
68: nOnlItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
69: nImpDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;
70: nOnlDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;

Line 67: nImpItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;

63: nImpPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
64: nOnlPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
65: nImpLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
66: nOnlLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
67: nImpItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
68: nOnlItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
69: nImpDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;
70: nOnlDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;
71: nImpDecQtyFlag CZ_IMP_ITEM_MASTER.DECIMAL_QTY_FLAG%TYPE;

Line 68: nOnlItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;

64: nOnlPriUOMCode CZ_IMP_ITEM_MASTER.PRIMARY_UOM_CODE%TYPE;
65: nImpLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
66: nOnlLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
67: nImpItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
68: nOnlItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
69: nImpDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;
70: nOnlDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;
71: nImpDecQtyFlag CZ_IMP_ITEM_MASTER.DECIMAL_QTY_FLAG%TYPE;
72: nonlDecQtyFlag CZ_IMP_ITEM_MASTER.DECIMAL_QTY_FLAG%TYPE;

Line 69: nImpDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;

65: nImpLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
66: nOnlLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
67: nImpItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
68: nOnlItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
69: nImpDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;
70: nOnlDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;
71: nImpDecQtyFlag CZ_IMP_ITEM_MASTER.DECIMAL_QTY_FLAG%TYPE;
72: nonlDecQtyFlag CZ_IMP_ITEM_MASTER.DECIMAL_QTY_FLAG%TYPE;
73:

Line 70: nOnlDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;

66: nOnlLeadTime CZ_IMP_ITEM_MASTER.LEAD_TIME%TYPE;
67: nImpItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
68: nOnlItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
69: nImpDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;
70: nOnlDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;
71: nImpDecQtyFlag CZ_IMP_ITEM_MASTER.DECIMAL_QTY_FLAG%TYPE;
72: nonlDecQtyFlag CZ_IMP_ITEM_MASTER.DECIMAL_QTY_FLAG%TYPE;
73:
74:

Line 71: nImpDecQtyFlag CZ_IMP_ITEM_MASTER.DECIMAL_QTY_FLAG%TYPE;

67: nImpItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
68: nOnlItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
69: nImpDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;
70: nOnlDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;
71: nImpDecQtyFlag CZ_IMP_ITEM_MASTER.DECIMAL_QTY_FLAG%TYPE;
72: nonlDecQtyFlag CZ_IMP_ITEM_MASTER.DECIMAL_QTY_FLAG%TYPE;
73:
74:
75:

Line 72: nonlDecQtyFlag CZ_IMP_ITEM_MASTER.DECIMAL_QTY_FLAG%TYPE;

68: nOnlItemStatus CZ_IMP_ITEM_MASTER.ITEM_STATUS%TYPE;
69: nImpDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;
70: nOnlDeletedFlag CZ_IMP_ITEM_MASTER.DELETED_FLAG%TYPE;
71: nImpDecQtyFlag CZ_IMP_ITEM_MASTER.DECIMAL_QTY_FLAG%TYPE;
72: nonlDecQtyFlag CZ_IMP_ITEM_MASTER.DECIMAL_QTY_FLAG%TYPE;
73:
74:
75:
76:

Line 77: nImpSrcTypeCode CZ_IMP_ITEM_MASTER.SRC_TYPE_CODE%TYPE;

73:
74:
75:
76:
77: nImpSrcTypeCode CZ_IMP_ITEM_MASTER.SRC_TYPE_CODE%TYPE;
78:
79: p_onl_itemtype_itemtypeid CHAR(1);
80: /* Internal vars */
81: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */

Line 244: UPDATE CZ_IMP_ITEM_MASTER

240: END IF;
241: END;
242: END IF;
243:
244: UPDATE CZ_IMP_ITEM_MASTER
245: SET ITEM_ID=DECODE(sDISPOSITION,'R',ITEM_ID,'I',nNextValue+nAllocateCounter, nOnlItemId),
246: ITEM_TYPE_ID=DECODE(sDISPOSITION,'R',ITEM_TYPE_ID,nOnlItemTypeId),
247: DISPOSITION=sDisposition,
248: REC_STATUS=sRecStatus

Line 567: (SELECT NULL FROM cz_imp_item_master

563: WHERE run_id = inRUN_ID AND deleted_flag = '0'
564: AND item_id = iv.item_id
565: AND property_id = iv.property_id)
566: AND EXISTS
567: (SELECT NULL FROM cz_imp_item_master
568: WHERE item_id = iv.item_id
569: AND run_id = inRUN_ID)
570: AND EXISTS
571: (SELECT NULL FROM cz_properties