DBA Data[Home] [Help]

APPS.INV_DIAG_ITEM dependencies on STANDARD

Line 102: if INV_DIAG_GRP.g_grp_name is null then --standard alone test for item

98: FETCH c_item_info INTO l_item;
99: CLOSE c_item_info;
100:
101:
102: if INV_DIAG_GRP.g_grp_name is null then --standard alone test for item
103: --fnd_file.put_line(fnd_file.log,'@@@ item grp null');
104: sqltxt := 'SELECT language "Language" '||
105: ', description "Description" '||
106: ', long_description "Long Description" '||

Line 128: ',DECODE(mp.primary_cost_method,1,''Standard'', 2,''Average'', 3,''Periodic Average'',4,''Periodic Incremental LIFO'', 5,''FIFO'', 6,''LIFO'', mp.primary_cost_method) "Primary Cost Method" '||

124: ',DECODE(mp.serial_number_type,1,''Unique within inventory items'', 2,''Unique within organization'', 3,''Unique across organizations'', '||
125: ' mp.serial_number_type) "Serial Number Type" '||
126: ',DECODE(mp.stock_locator_control_code,1,''None'', 2,''Prespecified'', 3,''Dynamic entry'', 4,''At subinventory level'', 5,''At item level'', '||
127: ' mp.stock_locator_control_code) "Locator|Control" '||
128: ',DECODE(mp.primary_cost_method,1,''Standard'', 2,''Average'', 3,''Periodic Average'',4,''Periodic Incremental LIFO'', 5,''FIFO'', 6,''LIFO'', mp.primary_cost_method) "Primary Cost Method" '||
129: ',mp.default_cost_group_id "Default|Cost Group|Id" '||
130: ',mp.wsm_enabled_flag "WSM|Enabled" '||
131: ',mp.process_enabled_flag "Process|Enabled" '||
132: ',DECODE( TO_CHAR( NVL(mp.project_reference_enabled, 2)),''1'', ''Yes'', ''2'', ''No'' , TO_CHAR( mp.project_reference_enabled ) )|| '' ('' ||mp.project_reference_enabled||'')'' "Project Reference Enabled" '||