66: );
67:
68: TYPE gmd_substitution_dtl_rec_type IS RECORD
69: (
70: INVENTORY_ITEM_ID gmd_item_substitution_dtl.inventory_item_id%TYPE
71: , ITEM_NO VARCHAR2(1000)
72: , UNIT_QTY gmd_item_substitution_dtl.unit_qty%TYPE
73: , DETAIL_UOM gmd_item_substitution_dtl.detail_uom%TYPE
74: , CREATION_DATE gmd_item_substitution_dtl.creation_date%TYPE
68: TYPE gmd_substitution_dtl_rec_type IS RECORD
69: (
70: INVENTORY_ITEM_ID gmd_item_substitution_dtl.inventory_item_id%TYPE
71: , ITEM_NO VARCHAR2(1000)
72: , UNIT_QTY gmd_item_substitution_dtl.unit_qty%TYPE
73: , DETAIL_UOM gmd_item_substitution_dtl.detail_uom%TYPE
74: , CREATION_DATE gmd_item_substitution_dtl.creation_date%TYPE
75: , CREATED_BY gmd_item_substitution_dtl.created_by%TYPE
76: , LAST_UPDATE_DATE gmd_item_substitution_dtl.last_update_date%TYPE
69: (
70: INVENTORY_ITEM_ID gmd_item_substitution_dtl.inventory_item_id%TYPE
71: , ITEM_NO VARCHAR2(1000)
72: , UNIT_QTY gmd_item_substitution_dtl.unit_qty%TYPE
73: , DETAIL_UOM gmd_item_substitution_dtl.detail_uom%TYPE
74: , CREATION_DATE gmd_item_substitution_dtl.creation_date%TYPE
75: , CREATED_BY gmd_item_substitution_dtl.created_by%TYPE
76: , LAST_UPDATE_DATE gmd_item_substitution_dtl.last_update_date%TYPE
77: , LAST_UPDATED_BY gmd_item_substitution_dtl.last_updated_by%TYPE
70: INVENTORY_ITEM_ID gmd_item_substitution_dtl.inventory_item_id%TYPE
71: , ITEM_NO VARCHAR2(1000)
72: , UNIT_QTY gmd_item_substitution_dtl.unit_qty%TYPE
73: , DETAIL_UOM gmd_item_substitution_dtl.detail_uom%TYPE
74: , CREATION_DATE gmd_item_substitution_dtl.creation_date%TYPE
75: , CREATED_BY gmd_item_substitution_dtl.created_by%TYPE
76: , LAST_UPDATE_DATE gmd_item_substitution_dtl.last_update_date%TYPE
77: , LAST_UPDATED_BY gmd_item_substitution_dtl.last_updated_by%TYPE
78: , LAST_UPDATE_LOGIN gmd_item_substitution_dtl.last_update_login%TYPE
71: , ITEM_NO VARCHAR2(1000)
72: , UNIT_QTY gmd_item_substitution_dtl.unit_qty%TYPE
73: , DETAIL_UOM gmd_item_substitution_dtl.detail_uom%TYPE
74: , CREATION_DATE gmd_item_substitution_dtl.creation_date%TYPE
75: , CREATED_BY gmd_item_substitution_dtl.created_by%TYPE
76: , LAST_UPDATE_DATE gmd_item_substitution_dtl.last_update_date%TYPE
77: , LAST_UPDATED_BY gmd_item_substitution_dtl.last_updated_by%TYPE
78: , LAST_UPDATE_LOGIN gmd_item_substitution_dtl.last_update_login%TYPE
79: );
72: , UNIT_QTY gmd_item_substitution_dtl.unit_qty%TYPE
73: , DETAIL_UOM gmd_item_substitution_dtl.detail_uom%TYPE
74: , CREATION_DATE gmd_item_substitution_dtl.creation_date%TYPE
75: , CREATED_BY gmd_item_substitution_dtl.created_by%TYPE
76: , LAST_UPDATE_DATE gmd_item_substitution_dtl.last_update_date%TYPE
77: , LAST_UPDATED_BY gmd_item_substitution_dtl.last_updated_by%TYPE
78: , LAST_UPDATE_LOGIN gmd_item_substitution_dtl.last_update_login%TYPE
79: );
80:
73: , DETAIL_UOM gmd_item_substitution_dtl.detail_uom%TYPE
74: , CREATION_DATE gmd_item_substitution_dtl.creation_date%TYPE
75: , CREATED_BY gmd_item_substitution_dtl.created_by%TYPE
76: , LAST_UPDATE_DATE gmd_item_substitution_dtl.last_update_date%TYPE
77: , LAST_UPDATED_BY gmd_item_substitution_dtl.last_updated_by%TYPE
78: , LAST_UPDATE_LOGIN gmd_item_substitution_dtl.last_update_login%TYPE
79: );
80:
81: TYPE gmd_fmsubstitution_rec_type IS RECORD
74: , CREATION_DATE gmd_item_substitution_dtl.creation_date%TYPE
75: , CREATED_BY gmd_item_substitution_dtl.created_by%TYPE
76: , LAST_UPDATE_DATE gmd_item_substitution_dtl.last_update_date%TYPE
77: , LAST_UPDATED_BY gmd_item_substitution_dtl.last_updated_by%TYPE
78: , LAST_UPDATE_LOGIN gmd_item_substitution_dtl.last_update_login%TYPE
79: );
80:
81: TYPE gmd_fmsubstitution_rec_type IS RECORD
82: (