APPS.WMS_RULE_EXTN_PVT dependencies on MTL_SYSTEM_ITEMS

Line 89: l_rev_control_code MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE%type;

85: ,x_tree_id out nocopy number
86: ) is
87:
88: l_api_name VARCHAR2(30) := 'InitQtyTree';
89: l_rev_control_code MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE%type;
90: l_lot_control_code MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE%type;
91: l_ser_control_code MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%type;
92: l_is_revision_control boolean;
93: l_is_lot_control boolean;

Line 90: l_lot_control_code MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE%type;

86: ) is
87:
88: l_api_name VARCHAR2(30) := 'InitQtyTree';
89: l_rev_control_code MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE%type;
90: l_lot_control_code MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE%type;
91: l_ser_control_code MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%type;
92: l_is_revision_control boolean;
93: l_is_lot_control boolean;
94: l_is_serial_control boolean;

Line 91: l_ser_control_code MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%type;

87:
88: l_api_name VARCHAR2(30) := 'InitQtyTree';
89: l_rev_control_code MTL_SYSTEM_ITEMS.REVISION_QTY_CONTROL_CODE%type;
90: l_lot_control_code MTL_SYSTEM_ITEMS.LOT_CONTROL_CODE%type;
91: l_ser_control_code MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%type;
92: l_is_revision_control boolean;
93: l_is_lot_control boolean;
94: l_is_serial_control boolean;
95: l_msg_data VARCHAR2(240);

Line 103: from MTL_SYSTEM_ITEMS msi

99: cursor iteminfo is
100: select nvl(msi.REVISION_QTY_CONTROL_CODE,1)
101: ,nvl(msi.LOT_CONTROL_CODE,1)
102: ,nvl(msi.SERIAL_NUMBER_CONTROL_CODE,1)
103: from MTL_SYSTEM_ITEMS msi
104: where ORGANIZATION_ID = p_organization_id
105: and INVENTORY_ITEM_ID = p_inventory_item_id
106: ;
107: begin