DBA Data[Home] [Help]

APPS.GR_TECHNICAL_PARAMETERS dependencies on LM_ITEM_DAT

Line 81: FROM lm_item_dat

77:
78:
79: CURSOR Cur_get_num(p_TECH_PARM_ID NUMBER) IS
80: SELECT num_data
81: FROM lm_item_dat
82: WHERE organization_id = p_organization_id
83: AND tech_parm_name = X_desc.label_description
84: AND inventory_item_id = p_inventory_item_id
85: AND tech_parm_id = p_TECH_PARM_ID;

Line 90: FROM lm_item_dat

86: X_num_data Cur_get_num%ROWTYPE;
87:
88: CURSOR Cur_get_text(p_TECH_PARM_ID NUMBER) IS
89: SELECT text_data
90: FROM lm_item_dat
91: WHERE organization_id = p_organization_id
92: AND tech_parm_name = X_desc.label_description
93: AND inventory_item_id = p_inventory_item_id
94: AND tech_parm_id = p_TECH_PARM_ID;

Line 99: FROM lm_item_dat

95: X_text_data Cur_get_text%ROWTYPE;
96:
97: CURSOR Cur_get_boolean(p_TECH_PARM_ID NUMBER) IS
98: SELECT boolean_data
99: FROM lm_item_dat
100: WHERE organization_id = p_organization_id
101: AND tech_parm_name = X_desc.label_description
102: AND inventory_item_id = p_inventory_item_id
103: AND tech_parm_id = p_TECH_PARM_ID;