DBA Data[Home] [Help]

APPS.ECE_INVENTORY dependencies on MTL_ITEM_FLEXFIELDS

Line 34: FROM MTL_ITEM_FLEXFIELDS MSIV

30:
31: IF i_item_id IS NOT NULL THEN
32:
33: SELECT MIN(ITEM_NUMBER) INTO cItem_num
34: FROM MTL_ITEM_FLEXFIELDS MSIV
35: WHERE MSIV.ITEM_ID = i_item_id
36: AND MSIV.ORGANIZATION_ID = i_org_id;
37:
38: IF cItem_num IS NOT NULL THEN

Line 72: FROM MTL_ITEM_FLEXFIELDS MSIV

68: o_attribute_12,
69: o_attribute_13,
70: o_attribute_14,
71: o_attribute_15
72: FROM MTL_ITEM_FLEXFIELDS MSIV
73: WHERE MSIV.ITEM_ID = i_item_id
74: AND MSIV.ORGANIZATION_ID = i_org_id
75: AND MSIV.ITEM_NUMBER = cItem_num
76: AND ROWNUM = 1;