DBA Data[Home] [Help]

APPS.INVTROAP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 691: /* Commented the select statement from MTL_SYSTEM_ITEMS_KFV AND

687: l_org_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
688: itemkey => itemkey,
689: aname => 'ORG_ID');
690:
691: /* Commented the select statement from MTL_SYSTEM_ITEMS_KFV AND
692: Selected the values of item name, planner code and description
693: from MTL_SYSTEM_ITEMS_VL which supports MLS.
694: Select Concatenated_segments , planner_code, description -- Description added for Bug# 4148672
695: into l_item_name , l_planner_code, l_item_description -- l_item_description added for Bug# 4148672

Line 696: from MTL_SYSTEM_ITEMS_KFV

692: Selected the values of item name, planner code and description
693: from MTL_SYSTEM_ITEMS_VL which supports MLS.
694: Select Concatenated_segments , planner_code, description -- Description added for Bug# 4148672
695: into l_item_name , l_planner_code, l_item_description -- l_item_description added for Bug# 4148672
696: from MTL_SYSTEM_ITEMS_KFV
697: where organization_id = l_org_id and
698: inventory_item_id = l_item_id;*/
699:
700: Select

Line 1222: from MTL_SYSTEM_ITEMS_KFV

1218:
1219: --bug9315598 add planner_code to line level, to make sure approver name appears in line approved notification
1220: Select planner_code
1221: into l_planner_code
1222: from MTL_SYSTEM_ITEMS_KFV
1223: where organization_id = l_org_id and
1224: inventory_item_id = l_trolin_tbl(l_current_line).inventory_item_id;
1225:
1226: wf_engine.setitemattrtext( itemtype => itemtype,