eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.INVUPD2B dependencies on MTL_SYSTEM_ITEMS

Line 343: MTL_SYSTEM_ITEMS_INTERFACE

339: INVENTORY_ITEM_ID,
340: ORGANIZATION_ID,
341: TRANSACTION_ID
342: FROM
343: MTL_SYSTEM_ITEMS_INTERFACE
344: WHERE
345: process_flag = 4
346: AND set_process_id = xset_id
347: AND ( (organization_id = org_id) or (all_org = 1) )

Line 354: (select 1 from mtl_system_items_interface

350: from MTL_PARAMETERS
351: where organization_id = master_organization_id
352: )
353: AND not exists
354: (select 1 from mtl_system_items_interface
355: where set_process_id = xset_id + 1000000000000
356: and transaction_type = 'AUTO_CHILD'
357: and process_flag = 4
358: );

Line 723: FROM mtl_system_items_interface

719: prog_id,
720: request_id);
721: --Bug3994245 If validations fail on the master item then AUTO_CHILD records should not be created-Anmurali
722: SELECT process_flag into m_process_flag
723: FROM mtl_system_items_interface
724: WHERE rowid = rec.rowid;
725:
726:
727: if (ret_code_update = 0 AND m_process_flag=4) THEN

Line 743: update mtl_system_items_interface

739: tmp_xset_id); --5351611
740: -- xset_id);
741:
742: --5351611
743: update mtl_system_items_interface
744: set set_process_id = xset_id + 1000000000000
745: where set_process_id = tmp_xset_id + 1000000000000 ; --5405867
746:
747: if (ret_code = 0) then

Line 748: update mtl_system_items_interface

744: set set_process_id = xset_id + 1000000000000
745: where set_process_id = tmp_xset_id + 1000000000000 ; --5405867
746:
747: if (ret_code = 0) then
748: update mtl_system_items_interface
749: set process_flag = 4
750: where inventory_item_id = rec.inventory_item_id
751: and SET_PROCESS_ID = xset_id + 1000000000000
752: and TRANSACTION_TYPE = 'AUTO_CHILD';

Line 766: 'MTL_SYSTEM_ITEMS_INTERFACE',

762: request_id,
763: t_trans_id,
764: error_text,
765: null,
766: 'MTL_SYSTEM_ITEMS_INTERFACE',
767: 'INV_CHILD_VIOLATION_ERROR',
768: err_text);
769: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
770: end if;

Line 817: m_Item_rec MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;

813: (20, 25, 30, 31, 35, 40, 41, 51, 60,
814: 62, 65, 70, 80, 90, 100, 120, 130));
815:
816: l_Attribute_Code mtl_item_attributes.attribute_name%TYPE;
817: m_Item_rec MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;
818: l_Item_rec MTL_SYSTEM_ITEMS_VL%ROWTYPE;
819: l_create_child BOOLEAN := FALSE;
820:
821: BEGIN

Line 818: l_Item_rec MTL_SYSTEM_ITEMS_VL%ROWTYPE;

814: 62, 65, 70, 80, 90, 100, 120, 130));
815:
816: l_Attribute_Code mtl_item_attributes.attribute_name%TYPE;
817: m_Item_rec MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;
818: l_Item_rec MTL_SYSTEM_ITEMS_VL%ROWTYPE;
819: l_create_child BOOLEAN := FALSE;
820:
821: BEGIN
822:

Line 825: FROM mtl_system_items_interface

821: BEGIN
822:
823: INVPUTLI.info('INVUPD2 : Begin Check create auto child ' );
824: SELECT * INTO m_Item_rec
825: FROM mtl_system_items_interface
826: WHERE rowid = mast_rowid;
827:
828: SELECT * INTO l_Item_rec
829: FROM mtl_system_items_vl

Line 829: FROM mtl_system_items_vl

825: FROM mtl_system_items_interface
826: WHERE rowid = mast_rowid;
827:
828: SELECT * INTO l_Item_rec
829: FROM mtl_system_items_vl
830: WHERE inventory_item_id = item_id
831: AND organization_id = org_id;
832:
833: OPEN c_master_attributes;

Line 1434: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP

1430: CURSOR C_msi_child_records is
1431: select
1432: MSI.INVENTORY_ITEM_ID,
1433: MSI.ORGANIZATION_ID
1434: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP
1435: where MP.master_organization_id = org_id
1436: and MP.organization_id = MSI.organization_id
1437: and MSI.inventory_item_id = inv_item_id
1438: and MSI.organization_id <> MP.master_organization_id;

Line 1443: from MTL_SYSTEM_ITEMS_INTERFACE

1439:
1440: CURSOR C_msii_forupdate_records is
1441: select
1442: ROWID, ORGANIZATION_ID
1443: from MTL_SYSTEM_ITEMS_INTERFACE
1444: where SET_PROCESS_ID = xset_id + 1000000000000
1445: and PROCESS_FLAG = 4
1446: and INVENTORY_ITEM_ID = inv_item_id;
1447:

Line 1565: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

1561: END IF;
1562: -- Insert msi data onto MSII for child record.
1563: -- Need to verify these attributes.
1564: --
1565: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
1566: (
1567: TRANSACTION_ID,
1568: INVENTORY_ITEM_ID,
1569: ORGANIZATION_ID,

Line 1966: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,

1962: TRADE_ITEM_DESCRIPTOR,
1963: STYLE_ITEM_FLAG,
1964: STYLE_ITEM_ID)
1965: SELECT
1966: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,
1967: inv_item_id,
1968: org_id,
1969: xset_id + 1000000000000,
1970: 'AUTO_CHILD',

Line 2364: MTL_SYSTEM_ITEMS_VL MSI

2360: MSI.TRADE_ITEM_DESCRIPTOR,
2361: MSI.STYLE_ITEM_FLAG,
2362: MSI.STYLE_ITEM_ID
2363: FROM
2364: MTL_SYSTEM_ITEMS_VL MSI
2365: WHERE
2366: MSI.inventory_item_id = inv_item_id
2367: AND MSI.organization_id = org_id;
2368:

Line 2407: msii_master_temp mtl_system_items_interface%ROWTYPE;

2403: IS
2404:
2405: -- temprec to hold master record data from msii
2406: --
2407: msii_master_temp mtl_system_items_interface%ROWTYPE;
2408:
2409: l_process_flag_2 NUMBER := 2;
2410:
2411: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

Line 2424: MTL_SYSTEM_ITEMS_INTERFACE MSII

2420: --
2421: select *
2422: into msii_master_temp
2423: from
2424: MTL_SYSTEM_ITEMS_INTERFACE MSII
2425: where
2426: MSII.ROWID = master_row_id;
2427:
2428: -- Update child record with master record data for attributes

Line 2431: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII

2427:
2428: -- Update child record with master record data for attributes
2429: -- under master control.
2430: --
2431: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
2432: SET MSII.ALLOWED_UNITS_LOOKUP_CODE = decode( A_ALLOWED_UNITS_LOOKUP_CODE,1,msii_master_temp.ALLOWED_UNITS_LOOKUP_CODE,MSII.ALLOWED_UNITS_LOOKUP_CODE ),
2433: MSII.INVENTORY_ITEM_STATUS_CODE = decode( A_INVENTORY_ITEM_STATUS_CODE,1, msii_master_temp.INVENTORY_ITEM_STATUS_CODE,MSII.INVENTORY_ITEM_STATUS_CODE ),
2434: MSII.ITEM_TYPE = decode( A_ITEM_TYPE,1,msii_master_temp.ITEM_TYPE,MSII.ITEM_TYPE ),
2435: MSII.PRIMARY_UNIT_OF_MEASURE = decode( A_PRIMARY_UNIT_OF_MEASURE,1,msii_master_temp.PRIMARY_UNIT_OF_MEASURE,MSII.PRIMARY_UNIT_OF_MEASURE ),

Line 3436: from MTL_SYSTEM_ITEMS_INTERFACE

3432: ROWID,
3433: INVENTORY_ITEM_ID,
3434: ORGANIZATION_ID,
3435: TRANSACTION_ID
3436: from MTL_SYSTEM_ITEMS_INTERFACE
3437: where process_flag = 4
3438: and set_process_id = xset_id
3439: and ((organization_id = org_id) or (all_org = 1))
3440: and organization_id in

Line 3505: msii_temp mtl_system_items_interface%ROWTYPE;

3501: request_id NUMBER := -1
3502: )
3503: RETURN INTEGER
3504: IS
3505: msii_temp mtl_system_items_interface%ROWTYPE;
3506: msi_temp mtl_system_items_b%ROWTYPE;
3507:
3508: dumm_status NUMBER;
3509: status NUMBER;

Line 3506: msi_temp mtl_system_items_b%ROWTYPE;

3502: )
3503: RETURN INTEGER
3504: IS
3505: msii_temp mtl_system_items_interface%ROWTYPE;
3506: msi_temp mtl_system_items_b%ROWTYPE;
3507:
3508: dumm_status NUMBER;
3509: status NUMBER;
3510:

Line 3590: from MTL_SYSTEM_ITEMS_INTERFACE MSII

3586:
3587: -- msii (updated to)
3588: select *
3589: into msii_temp
3590: from MTL_SYSTEM_ITEMS_INTERFACE MSII
3591: where MSII.rowid = row_id;
3592:
3593: -- msi (updated from)
3594: select *

Line 3596: from MTL_SYSTEM_ITEMS_B MSI

3592:
3593: -- msi (updated from)
3594: select *
3595: into msi_temp
3596: from MTL_SYSTEM_ITEMS_B MSI
3597: where MSI.organization_id = msii_temp.organization_id
3598: and msi.inventory_item_id = msii_temp.inventory_item_id ;
3599:
3600: select master_organization_id

Line 3869: 'MTL_SYSTEM_ITEMS_INTERFACE',

3865: request_id,
3866: trans_id,
3867: err_text,
3868: 'LOT_CONTROL_CODE',
3869: 'MTL_SYSTEM_ITEMS_INTERFACE',
3870: 'INV_LOT_QOH_CANNOT_UPDATE',
3871: err_text);
3872:
3873: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 3887: 'MTL_SYSTEM_ITEMS_INTERFACE',

3883: request_id,
3884: trans_id,
3885: err_text,
3886: 'LOT_CONTROL_CODE',
3887: 'MTL_SYSTEM_ITEMS_INTERFACE',
3888: 'INV_PENDING_ADJUSTMENT',
3889: err_text);
3890:
3891: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 3905: 'MTL_SYSTEM_ITEMS_INTERFACE',

3901: request_id,
3902: trans_id,
3903: err_text,
3904: 'LOT_CONTROL_CODE',
3905: 'MTL_SYSTEM_ITEMS_INTERFACE',
3906: 'INV_INTRANSIT_CANNOT_UPDATE',
3907: err_text);
3908:
3909: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 3922: 'MTL_SYSTEM_ITEMS_INTERFACE',

3918: request_id,
3919: trans_id,
3920: err_text,
3921: 'LOT_CONTROL_CODE',
3922: 'MTL_SYSTEM_ITEMS_INTERFACE',
3923: 'INV_DELIVER_CANNOT_UPDATE',
3924: err_text);
3925:
3926: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 3944: 'MTL_SYSTEM_ITEMS_INTERFACE',

3940: request_id,
3941: trans_id,
3942: err_text,
3943: 'CHILD_LOT_FLAG',
3944: 'MTL_SYSTEM_ITEMS_INTERFACE',
3945: 'INV_LOT_QOH_CANNOT_UPDATE',
3946: err_text);
3947:
3948: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 3961: 'MTL_SYSTEM_ITEMS_INTERFACE',

3957: request_id,
3958: trans_id,
3959: err_text,
3960: 'CHILD_LOT_FLAG',
3961: 'MTL_SYSTEM_ITEMS_INTERFACE',
3962: 'INV_PENDING_ADJUSTMENT',
3963: err_text);
3964:
3965: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 3982: 'MTL_SYSTEM_ITEMS_INTERFACE',

3978: request_id,
3979: trans_id,
3980: err_text,
3981: 'GRADE_CONTROL_FLAG',
3982: 'MTL_SYSTEM_ITEMS_INTERFACE',
3983: 'INV_LOT_QOH_CANNOT_UPDATE',
3984: err_text);
3985:
3986: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 3999: 'MTL_SYSTEM_ITEMS_INTERFACE',

3995: request_id,
3996: trans_id,
3997: err_text,
3998: 'GRADE_CONTROL_FLAG',
3999: 'MTL_SYSTEM_ITEMS_INTERFACE',
4000: 'INV_PENDING_ADJUSTMENT',
4001: err_text);
4002:
4003: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4020: 'MTL_SYSTEM_ITEMS_INTERFACE',

4016: request_id,
4017: trans_id,
4018: err_text,
4019: 'LOT_DIVISIBLE_FLAG',
4020: 'MTL_SYSTEM_ITEMS_INTERFACE',
4021: 'INV_LOT_QOH_CANNOT_UPDATE',
4022: err_text);
4023:
4024: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4037: 'MTL_SYSTEM_ITEMS_INTERFACE',

4033: request_id,
4034: trans_id,
4035: err_text,
4036: 'LOT_DIVISIBLE_FLAG',
4037: 'MTL_SYSTEM_ITEMS_INTERFACE',
4038: 'INV_PENDING_ADJUSTMENT',
4039: err_text);
4040:
4041: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4065: 'MTL_SYSTEM_ITEMS_INTERFACE',

4061: request_id,
4062: trans_id,
4063: err_text,
4064: 'SHELF_LIFE_CODE',
4065: 'MTL_SYSTEM_ITEMS_INTERFACE',
4066: 'INV_LOT_QOH_CANNOT_UPDATE',
4067: err_text);
4068:
4069: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4089: 'MTL_SYSTEM_ITEMS_INTERFACE',

4085: request_id,
4086: trans_id,
4087: err_text,
4088: 'LOCATION_CONTROL_CODE',
4089: 'MTL_SYSTEM_ITEMS_INTERFACE',
4090: 'INV_LOC_CONTROL_CODE_ERR',
4091: err_text);
4092:
4093: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4106: 'MTL_SYSTEM_ITEMS_INTERFACE',

4102: request_id,
4103: trans_id,
4104: err_text,
4105: 'LOCATION_CONTROL_CODE',
4106: 'MTL_SYSTEM_ITEMS_INTERFACE',
4107: 'INV_PENDING_ADJUSTMENT',
4108: err_text);
4109:
4110: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4130: 'MTL_SYSTEM_ITEMS_INTERFACE',

4126: request_id,
4127: trans_id,
4128: err_text,
4129: 'RESERVABLE_TYPE',
4130: 'MTL_SYSTEM_ITEMS_INTERFACE',
4131: 'INV_RESERVABLE_TYPE_ERR',
4132: err_text);
4133:
4134: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4153: 'MTL_SYSTEM_ITEMS_INTERFACE',

4149: request_id,
4150: trans_id,
4151: err_text,
4152: 'RESERVABLE_TYPE',
4153: 'MTL_SYSTEM_ITEMS_INTERFACE',
4154: 'INV_RESERVABLE_NO_YES',
4155: err_text);
4156: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4157: end if;

Line 4181: 'MTL_SYSTEM_ITEMS_INTERFACE',

4177: request_id,
4178: trans_id,
4179: err_text,
4180: 'TRANSACTIONS_ENABLED_FLAG',
4181: 'MTL_SYSTEM_ITEMS_INTERFACE',
4182: 'INV_TRANSACTABLE_YES_NO',
4183: err_text);
4184: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4185: end if;

Line 4208: 'MTL_SYSTEM_ITEMS_INTERFACE',

4204: request_id,
4205: trans_id,
4206: err_text,
4207: 'SHIPPABLE_ITEM_FLAG',
4208: 'MTL_SYSTEM_ITEMS_INTERFACE',
4209: 'INV_OPEN_SO',
4210: err_text);
4211: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4212: elsif (msi_temp.SHIPPABLE_ITEM_FLAG = 'N' ) and (msii_temp.SHIPPABLE_ITEM_FLAG = 'Y') then

Line 4225: 'MTL_SYSTEM_ITEMS_INTERFACE',

4221: request_id,
4222: trans_id,
4223: err_text,
4224: 'SHIPPABLE_ITEM_FLAG',
4225: 'MTL_SYSTEM_ITEMS_INTERFACE',
4226: 'INV_TRANSACTABLE_NO_YES',
4227: err_text);
4228: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4229: end if;

Line 4251: 'MTL_SYSTEM_ITEMS_INTERFACE',

4247: request_id,
4248: trans_id,
4249: err_text,
4250: 'REPLENISH_TO_ORDER_FLAG',
4251: 'MTL_SYSTEM_ITEMS_INTERFACE',
4252: 'INV_ATO_YES_NO',
4253: err_text);
4254: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4255: end if;

Line 4273: 'MTL_SYSTEM_ITEMS_INTERFACE',

4269: request_id,
4270: trans_id,
4271: err_text,
4272: 'REVISION_QTY_CONTROL_CODE',
4273: 'MTL_SYSTEM_ITEMS_INTERFACE',
4274: 'INV_REV_QTY_CNTRL_CODE_ERR',
4275: err_text);
4276:
4277: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4290: 'MTL_SYSTEM_ITEMS_INTERFACE',

4286: request_id,
4287: trans_id,
4288: err_text,
4289: 'REVISION_QTY_CONTROL_CODE',
4290: 'MTL_SYSTEM_ITEMS_INTERFACE',
4291: 'INV_DELIVER_CANNOT_UPDATE',
4292: err_text);
4293: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4294: /*Bug 6501149 Code ends */

Line 4308: 'MTL_SYSTEM_ITEMS_INTERFACE',

4304: request_id,
4305: trans_id,
4306: err_text,
4307: 'REVISION_QTY_CONTROL_CODE',
4308: 'MTL_SYSTEM_ITEMS_INTERFACE',
4309: 'INV_PENDING_ADJUSTMENT',
4310: err_text);
4311:
4312: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4339: 'MTL_SYSTEM_ITEMS_INTERFACE',

4335: request_id,
4336: trans_id,
4337: err_text,
4338: 'SERIAL_NUMBER_CONTROL_CODE',
4339: 'MTL_SYSTEM_ITEMS_INTERFACE',
4340: 'INV_QTY_ON_HAND',
4341: err_text);
4342: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4343: elsif (msi_temp.SERIAL_NUMBER_CONTROL_CODE = 1 and

Line 4358: 'MTL_SYSTEM_ITEMS_INTERFACE',

4354: request_id,
4355: trans_id,
4356: err_text,
4357: 'SERIAL_NUMBER_CONTROL_CODE',
4358: 'MTL_SYSTEM_ITEMS_INTERFACE',
4359: 'INV_SERIAL_NO_YES',
4360: err_text);
4361: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4362: end if;

Line 4381: 'MTL_SYSTEM_ITEMS_INTERFACE',

4377: request_id,
4378: trans_id,
4379: err_text,
4380: 'SERIAL_NUMBER_CONTROL_CODE',
4381: 'MTL_SYSTEM_ITEMS_INTERFACE',
4382: 'INV_INTRANSIT_CANNOT_UPDATE',
4383: err_text);
4384:
4385: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4403: 'MTL_SYSTEM_ITEMS_INTERFACE',

4399: request_id,
4400: trans_id,
4401: err_text,
4402: 'SERIAL_NUMBER_CONTROL_CODE',
4403: 'MTL_SYSTEM_ITEMS_INTERFACE',
4404: 'INV_DELIVER_CANNOT_UPDATE',
4405: err_text);
4406: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4407: /* Bug 6501149 Code ended */

Line 4426: 'MTL_SYSTEM_ITEMS_INTERFACE',

4422: request_id,
4423: trans_id,
4424: err_text,
4425: 'BOM_ENABLED_FLAG',
4426: 'MTL_SYSTEM_ITEMS_INTERFACE',
4427: 'INV_BOM_ENABLED_FLAG_ERR',
4428: err_text);
4429:
4430: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4451: 'MTL_SYSTEM_ITEMS_INTERFACE',

4447: request_id,
4448: trans_id,
4449: err_text,
4450: 'BOM_ITEM_TYPE',
4451: 'MTL_SYSTEM_ITEMS_INTERFACE',
4452: 'INV_BOM_ITEM_TYPE_ERR1',
4453: err_text);
4454:
4455: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4471: 'MTL_SYSTEM_ITEMS_INTERFACE',

4467: request_id,
4468: trans_id,
4469: err_text,
4470: 'BOM_ENABLED_FLAG',
4471: 'MTL_SYSTEM_ITEMS_INTERFACE',
4472: 'INV_IOI_ITEM_BOM_EXISTS',
4473: err_text);
4474:
4475: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4507: 'MTL_SYSTEM_ITEMS_INTERFACE',

4503: request_id,
4504: trans_id,
4505: err_text,
4506: 'BOM_ITEM_TYPE',
4507: 'MTL_SYSTEM_ITEMS_INTERFACE',
4508: 'INV_BOM_ITEM_TYPE_ERR2',
4509: err_text);
4510:
4511: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4532: 'MTL_SYSTEM_ITEMS_INTERFACE',

4528: request_id,
4529: trans_id,
4530: err_text,
4531: 'BOM_ITEM_TYPE',
4532: 'MTL_SYSTEM_ITEMS_INTERFACE',
4533: 'INV_BOM_ITEM_TYPE_ERR3',
4534: err_text);
4535:
4536: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4568: 'MTL_SYSTEM_ITEMS_INTERFACE',

4564: request_id,
4565: trans_id,
4566: err_text,
4567: 'PICK_COMPONENTS_FLAG',
4568: 'MTL_SYSTEM_ITEMS_INTERFACE',
4569: 'INV_ITEM_LOT_COMP',
4570: err_text);
4571: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4572: END IF;

Line 4593: 'MTL_SYSTEM_ITEMS_INTERFACE',

4589: request_id,
4590: trans_id,
4591: err_text,
4592: 'COSTING_ENABLED_FLAG',
4593: 'MTL_SYSTEM_ITEMS_INTERFACE',
4594: 'INV_COSTING_ENABLED_FLAG_ERR',
4595: err_text);
4596:
4597: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4619: 'MTL_SYSTEM_ITEMS_INTERFACE',

4615: request_id,
4616: trans_id,
4617: err_text,
4618: 'INVENTORY_ASSET_FLAG',
4619: 'MTL_SYSTEM_ITEMS_INTERFACE',
4620: 'INV_INVENTORY_ASSET_FLAG_ERR',
4621: err_text);
4622:
4623: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4641: 'MTL_SYSTEM_ITEMS_INTERFACE',

4637: request_id,
4638: trans_id,
4639: err_text,
4640: 'FIXED_ORDER_QUANTITY',
4641: 'MTL_SYSTEM_ITEMS_INTERFACE',
4642: 'INV_FIXED_ORDER_QUANTITY_ERR',
4643: err_text);
4644:
4645: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4664: 'MTL_SYSTEM_ITEMS_INTERFACE',

4660: request_id,
4661: trans_id,
4662: err_text,
4663: 'PLANNING_MAKE_BUY_CODE',
4664: 'MTL_SYSTEM_ITEMS_INTERFACE',
4665: 'INV_PLANNING_MAKE_BUY_CODE',
4666: err_text);
4667:
4668: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4686: 'MTL_SYSTEM_ITEMS_INTERFACE',

4682: request_id,
4683: trans_id,
4684: err_text,
4685: 'ACCEPTABLE_EARLY_DAYS',
4686: 'MTL_SYSTEM_ITEMS_INTERFACE',
4687: 'INV_ACCEPTABLE_EARLY_DAYS_ERR',
4688: err_text);
4689:
4690: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4708: 'MTL_SYSTEM_ITEMS_INTERFACE',

4704: request_id,
4705: trans_id,
4706: err_text,
4707: 'ACCEPTABLE_RATE_INCREASE',
4708: 'MTL_SYSTEM_ITEMS_INTERFACE',
4709: 'INV_ACCEPT_RATE_INCREASE_ERR',
4710: err_text);
4711:
4712: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4730: 'MTL_SYSTEM_ITEMS_INTERFACE',

4726: request_id,
4727: trans_id,
4728: err_text,
4729: 'ACCEPTABLE_RATE_DECREASE',
4730: 'MTL_SYSTEM_ITEMS_INTERFACE',
4731: 'INV_ACCEPT_RATE_DECREASE_ERR',
4732: err_text);
4733:
4734: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4753: 'MTL_SYSTEM_ITEMS_INTERFACE',

4749: request_id,
4750: trans_id,
4751: err_text,
4752: 'DEMAND_TIME_FENCE_DAYS',
4753: 'MTL_SYSTEM_ITEMS_INTERFACE',
4754: 'INV_DEMAND_TIME_FENCE_DAYS_ERR',
4755: err_text);
4756:
4757: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4776: 'MTL_SYSTEM_ITEMS_INTERFACE',

4772: request_id,
4773: trans_id,
4774: err_text,
4775: 'PLANNING_TIME_FENCE_DAYS',
4776: 'MTL_SYSTEM_ITEMS_INTERFACE',
4777: 'INV_PLAN_TIME_FENCE_DAYS_ERR',
4778: err_text);
4779:
4780: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4799: 'MTL_SYSTEM_ITEMS_INTERFACE',

4795: request_id,
4796: trans_id,
4797: err_text,
4798: 'REPETITIVE_PLANNING_FLAG',
4799: 'MTL_SYSTEM_ITEMS_INTERFACE',
4800: 'INV_REPET_PLANNING_FLAG_ERR',
4801: err_text);
4802:
4803: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4823: 'MTL_SYSTEM_ITEMS_INTERFACE',

4819: request_id,
4820: trans_id,
4821: err_text,
4822: 'SHRINKAGE_RATE',
4823: 'MTL_SYSTEM_ITEMS_INTERFACE',
4824: 'INV_SHRINKAGE_RATE_ERR',
4825: err_text);
4826:
4827: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4847: 'MTL_SYSTEM_ITEMS_INTERFACE',

4843: request_id,
4844: trans_id,
4845: err_text,
4846: 'FULL_LEAD_TIME',
4847: 'MTL_SYSTEM_ITEMS_INTERFACE',
4848: 'INV_FULL_LEAD_TIME_ERR',
4849: err_text);
4850:
4851: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4859: UPDATE mtl_system_items_interface

4855: -- validate LEAD_TIME_LOT_SIZE
4856: -- if null, set to std_lot_size
4857:
4858: if (msii_temp.lead_time_lot_size IS null) then
4859: UPDATE mtl_system_items_interface
4860: SET lead_time_lot_size = msii_temp.std_lot_size
4861: WHERE rowid = row_id;
4862:
4863: /* commit for debugging ONLY */

Line 4885: 'MTL_SYSTEM_ITEMS_INTERFACE',

4881: request_id,
4882: trans_id,
4883: err_text,
4884: 'POSTPROCESSING_LEAD_TIME',
4885: 'MTL_SYSTEM_ITEMS_INTERFACE',
4886: 'INV_POSTPROC_LEAD_TIME_ERR',
4887: err_text);
4888:
4889: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4907: 'MTL_SYSTEM_ITEMS_INTERFACE',

4903: request_id,
4904: trans_id,
4905: err_text,
4906: 'VARIABLE_LEAD_TIME',
4907: 'MTL_SYSTEM_ITEMS_INTERFACE',
4908: 'INV_VARIABLE_LEAD_TIME_ERR',
4909: err_text);
4910:
4911: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4926: 'MTL_SYSTEM_ITEMS_INTERFACE',

4922: request_id,
4923: trans_id,
4924: err_text,
4925: 'EFFECTIVITY_CONTROL',
4926: 'MTL_SYSTEM_ITEMS_INTERFACE',
4927: 'ITM-EFFC-ITEM IS BILL OR COMP',
4928: err_text);
4929:
4930: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4951: 'MTL_SYSTEM_ITEMS_INTERFACE',

4947: request_id,
4948: trans_id,
4949: err_text,
4950: 'BUILD_IN_WIP_FLAG',
4951: 'MTL_SYSTEM_ITEMS_INTERFACE',
4952: 'INV_BUILD_IN_WIP_FLAG_ERR',
4953: err_text);
4954:
4955: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4974: 'MTL_SYSTEM_ITEMS_INTERFACE',

4970: request_id,
4971: trans_id,
4972: err_text,
4973: 'SERVICE_ITEM_FLAG',
4974: 'MTL_SYSTEM_ITEMS_INTERFACE',
4975: 'INV_SERVICE_ITEM_FLAG_ERR',
4976: err_text);
4977:
4978: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4996: 'MTL_SYSTEM_ITEMS_INTERFACE',

4992: request_id,
4993: trans_id,
4994: err_text,
4995: 'SERVICE_STARTING_DELAY',
4996: 'MTL_SYSTEM_ITEMS_INTERFACE',
4997: 'INV_SERVICE_STARTING_DELAY_ERR',
4998: err_text);
4999:
5000: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5017: 'MTL_SYSTEM_ITEMS_INTERFACE',

5013: request_id,
5014: trans_id,
5015: err_text,
5016: 'VEHICLE_ITEM_FLAG',
5017: 'MTL_SYSTEM_ITEMS_INTERFACE',
5018: 'INV_VEHICLE_CANNOT_UPDATE',
5019: err_text);
5020:
5021: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5038: 'MTL_SYSTEM_ITEMS_INTERFACE',

5034: request_id,
5035: trans_id,
5036: err_text,
5037: 'COMMS_NL_TRACKABLE_FLAG',
5038: 'MTL_SYSTEM_ITEMS_INTERFACE',
5039: 'INV_ONHAND_TRACKABLE_EXIST',
5040: err_text);
5041:
5042: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5063: 'MTL_SYSTEM_ITEMS_INTERFACE',

5059: request_id,
5060: trans_id,
5061: err_text,
5062: 'STOCK_ENABLED_FLAG',
5063: 'MTL_SYSTEM_ITEMS_INTERFACE',
5064: 'INV_DELIVER_CANNOT_UPDATE',
5065: err_text);
5066: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5067: end if;

Line 5100: 'MTL_SYSTEM_ITEMS_INTERFACE',

5096: request_id,
5097: trans_id,
5098: err_text,
5099: l_column_name,
5100: 'MTL_SYSTEM_ITEMS_INTERFACE',
5101: 'INV_VMI_ENABLED_ITEM',
5102: err_text);
5103: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5104: end if;

Line 5126: 'MTL_SYSTEM_ITEMS_INTERFACE',

5122: request_id,
5123: trans_id,
5124: err_text,
5125: 'TRACKING_QUANTITY_IND',
5126: 'MTL_SYSTEM_ITEMS_INTERFACE',
5127: 'INV_QOH_CANNOT_UPDATE',
5128: err_text);
5129:
5130: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5146: 'MTL_SYSTEM_ITEMS_INTERFACE',

5142: request_id,
5143: trans_id,
5144: err_text,
5145: 'TRACKING_QUANTITY_IND',
5146: 'MTL_SYSTEM_ITEMS_INTERFACE',
5147: 'INV_PENDING_ADJUSTMENT',
5148: err_text);
5149:
5150: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5170: 'MTL_SYSTEM_ITEMS_INTERFACE',

5166: request_id,
5167: trans_id,
5168: err_text,
5169: 'SECONDARY_UOM_CODE',
5170: 'MTL_SYSTEM_ITEMS_INTERFACE',
5171: 'INV_QOH_CANNOT_UPDATE',
5172: err_text);
5173:
5174: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5190: 'MTL_SYSTEM_ITEMS_INTERFACE',

5186: request_id,
5187: trans_id,
5188: err_text,
5189: 'SECONDARY_UOM_CODE',
5190: 'MTL_SYSTEM_ITEMS_INTERFACE',
5191: 'INV_PENDING_ADJUSTMENT',
5192: err_text);
5193:
5194: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5214: 'MTL_SYSTEM_ITEMS_INTERFACE',

5210: request_id,
5211: trans_id,
5212: err_text,
5213: 'SECONDARY_DEFAULT_IND',
5214: 'MTL_SYSTEM_ITEMS_INTERFACE',
5215: 'INV_QOH_CANNOT_UPDATE',
5216: err_text);
5217:
5218: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5234: 'MTL_SYSTEM_ITEMS_INTERFACE',

5230: request_id,
5231: trans_id,
5232: err_text,
5233: 'SECONDARY_DEFAULT_IND',
5234: 'MTL_SYSTEM_ITEMS_INTERFACE',
5235: 'INV_PENDING_ADJUSTMENT',
5236: err_text);
5237:
5238: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5258: 'MTL_SYSTEM_ITEMS_INTERFACE',

5254: request_id,
5255: trans_id,
5256: err_text,
5257: 'PRIMARY_UOM_CODE',
5258: 'MTL_SYSTEM_ITEMS_INTERFACE',
5259: 'INV_QOH_CANNOT_UPDATE',
5260: err_text);
5261:
5262: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5278: 'MTL_SYSTEM_ITEMS_INTERFACE',

5274: request_id,
5275: trans_id,
5276: err_text,
5277: 'PRIMARY_UOM_CODE',
5278: 'MTL_SYSTEM_ITEMS_INTERFACE',
5279: 'INV_PENDING_ADJUSTMENT',
5280: err_text);
5281:
5282: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5302: 'MTL_SYSTEM_ITEMS_INTERFACE',

5298: request_id,
5299: trans_id,
5300: err_text,
5301: 'DUAL_UOM_DEVIATION_HIGH',
5302: 'MTL_SYSTEM_ITEMS_INTERFACE',
5303: 'INV_QOH_CANNOT_UPDATE',
5304: err_text);
5305:
5306: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5322: 'MTL_SYSTEM_ITEMS_INTERFACE',

5318: request_id,
5319: trans_id,
5320: err_text,
5321: 'DUAL_UOM_DEVIATION_HIGH',
5322: 'MTL_SYSTEM_ITEMS_INTERFACE',
5323: 'INV_PENDING_ADJUSTMENT',
5324: err_text);
5325:
5326: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5346: 'MTL_SYSTEM_ITEMS_INTERFACE',

5342: request_id,
5343: trans_id,
5344: err_text,
5345: 'DUAL_UOM_DEVIATION_LOW',
5346: 'MTL_SYSTEM_ITEMS_INTERFACE',
5347: 'INV_QOH_CANNOT_UPDATE',
5348: err_text);
5349:
5350: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5366: 'MTL_SYSTEM_ITEMS_INTERFACE',

5362: request_id,
5363: trans_id,
5364: err_text,
5365: 'DUAL_UOM_DEVIATION_LOW',
5366: 'MTL_SYSTEM_ITEMS_INTERFACE',
5367: 'INV_PENDING_ADJUSTMENT',
5368: err_text);
5369:
5370: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5413: FROM MTL_SYSTEM_ITEMS_INTERFACE msii

5409: --Fix bug 6974062(7442071,7001285)
5410: CURSOR C_msii_processed_records
5411: IS
5412: SELECT distinct msii.inventory_item_id
5413: FROM MTL_SYSTEM_ITEMS_INTERFACE msii
5414: WHERE
5415: ( set_process_id = xset_id OR
5416: set_process_id = xset_id + 1000000000000 )
5417: AND transaction_type IN ('UPDATE', 'AUTO_CHILD')

Line 5423: FROM MTL_SYSTEM_ITEMS_INTERFACE msii

5419:
5420: CURSOR C_msii_processed_records_dup
5421: IS
5422: SELECT distinct msii.inventory_item_id, organization_id, item_number
5423: FROM MTL_SYSTEM_ITEMS_INTERFACE msii
5424: WHERE
5425: ( set_process_id = xset_id OR
5426: set_process_id = xset_id + 1000000000000 )
5427: AND transaction_type IN ('UPDATE', 'AUTO_CHILD')

Line 5451: , mtl_system_items_interface msii

5447: , muom.base_uom_flag
5448: , muom.uom_class UOMCL
5449: FROM
5450: mtl_units_of_measure_vl muom
5451: , mtl_system_items_interface msii
5452: WHERE
5453: msii.process_flag = 4
5454: AND msii.allowed_units_lookup_code = 1
5455: AND(msii.set_process_id = xset_id OR

Line 5472: FROM mtl_system_items_interface msii,

5468: tl.language,
5469: tl.column_value,
5470: msii.inventory_item_id,
5471: msii.organization_id
5472: FROM mtl_system_items_interface msii,
5473: ego_interface_tl tl,
5474: mtl_system_items item
5475: WHERE item.inventory_item_id = msii.inventory_item_id
5476: AND item.organization_id = msii.organization_id

Line 5474: mtl_system_items item

5470: msii.inventory_item_id,
5471: msii.organization_id
5472: FROM mtl_system_items_interface msii,
5473: ego_interface_tl tl,
5474: mtl_system_items item
5475: WHERE item.inventory_item_id = msii.inventory_item_id
5476: AND item.organization_id = msii.organization_id
5477: AND msii.transaction_type in ('UPDATE','AUTO_CHILD')
5478: AND msii.process_flag = 4

Line 5482: AND UPPER(tl.table_name) = 'MTL_SYSTEM_ITEMS_INTERFACE'

5478: AND msii.process_flag = 4
5479: AND (msii.set_process_id = xset_id or msii.set_process_id = xset_id + 1000000000000)
5480: AND tl.unique_id = msii.transaction_id
5481: AND tl.set_process_id = msii.set_process_id
5482: AND UPPER(tl.table_name) = 'MTL_SYSTEM_ITEMS_INTERFACE'
5483: AND UPPER(tl.column_name) = 'DESCRIPTION'
5484: AND tl.language IN (SELECT l.language_code FROM fnd_languages l
5485: WHERE l.installed_flag IN ('I', 'B'));
5486:

Line 5501: FROM MTL_SYSTEM_ITEMS_INTERFACE

5497: -- Start fix for bug 7017691(7435552,7147893) Issue #2 Replacing COUNT(*) with CURSOR
5498: CURSOR c_duplicate_check(p_set_id NUMBER, p_inventory_item_id NUMBER,
5499: p_organization_id NUMBER) IS
5500: SELECT 1
5501: FROM MTL_SYSTEM_ITEMS_INTERFACE
5502: WHERE inventory_item_id = p_inventory_item_id
5503: AND organization_id = p_organization_id
5504: AND process_flag = 4
5505: AND set_process_id = p_set_id

Line 5518: FROM mtl_system_items_b_kfv msik,

5514: msii.segment1,msii.segment2,msii.segment3,msii.segment4,msii.segment5,
5515: msii.segment6,msii.segment7,msii.segment8,msii.segment9,msii.segment10,
5516: msii.segment11,msii.segment12,msii.segment13,msii.segment14,msii.segment15,
5517: msii.segment16,msii.segment17,msii.segment18,msii.segment19,msii.segment20
5518: FROM mtl_system_items_b_kfv msik,
5519: mtl_system_items_interface msii,
5520: mtl_parameters mp
5521: WHERE msii.set_process_id = xset_id
5522: AND msii.transaction_type = 'UPDATE'

Line 5519: mtl_system_items_interface msii,

5515: msii.segment6,msii.segment7,msii.segment8,msii.segment9,msii.segment10,
5516: msii.segment11,msii.segment12,msii.segment13,msii.segment14,msii.segment15,
5517: msii.segment16,msii.segment17,msii.segment18,msii.segment19,msii.segment20
5518: FROM mtl_system_items_b_kfv msik,
5519: mtl_system_items_interface msii,
5520: mtl_parameters mp
5521: WHERE msii.set_process_id = xset_id
5522: AND msii.transaction_type = 'UPDATE'
5523: AND msii.process_flag = 4

Line 5532: TYPE transaction_type IS TABLE OF mtl_system_items_interface.transaction_id%TYPE

5528: AND msii.item_number <> msik.concatenated_segments
5529: AND msik.concatenated_segments IS NOT NULL;
5530: -- End fix for bug 7017691 Issue #3
5531:
5532: TYPE transaction_type IS TABLE OF mtl_system_items_interface.transaction_id%TYPE
5533: INDEX BY BINARY_INTEGER;
5534:
5535: transaction_table transaction_type;
5536:

Line 5622: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

5618: CLOSE c_duplicate_check;
5619: -- End Fix for bug 7017691 Issue #2
5620:
5621: IF ext_flag > 1 THEN
5622: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
5623: SET process_flag = 3
5624: WHERE inventory_item_id = item_rec.inventory_item_id
5625: AND organization_id = item_rec.organization_id
5626: AND process_flag = 4

Line 5652: 'MTL_SYSTEM_ITEMS_INTERFACE',

5648: req_id,
5649: transaction_table(j),
5650: error_msg,
5651: 'INVENTORY_ITEM_ID',
5652: 'MTL_SYSTEM_ITEMS_INTERFACE',
5653: 'INV_IOI_ERR' ,
5654: err_text);
5655: END LOOP;
5656: END IF;

Line 5693: from MTL_SYSTEM_ITEMS_B msi, MTL_SYSTEM_ITEMS_INTERFACE msii

5689: msi.CONTRACT_ITEM_TYPE_CODE contract_type,
5690: msi.INVENTORY_ASSET_FLAG inv_asset_flag,--Bug:3899614
5691: msi.OBJECT_VERSION_NUMBER obj_ver_num,
5692: msii.ROWID msii_rowid, msii.*
5693: from MTL_SYSTEM_ITEMS_B msi, MTL_SYSTEM_ITEMS_INTERFACE msii
5694: where item_rec.inventory_item_id = msii.inventory_item_id
5695: and item_rec.inventory_item_id = msi.inventory_item_id
5696: and msii.transaction_type in ('UPDATE','AUTO_CHILD')
5697: and msi.organization_id = msii.organization_id

Line 5708: l_org_id mtl_system_items_interface.organization_id%TYPE;

5704: obj_version_error EXCEPTION;
5705: PRAGMA EXCEPTION_INIT (resource_busy, -54);
5706:
5707: -- 2810346: Lock failed record details into log
5708: l_org_id mtl_system_items_interface.organization_id%TYPE;
5709: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;
5710:
5711: l_target_lc_id mtl_system_items_b.lifecycle_id%TYPE;
5712:

Line 5709: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;

5705: PRAGMA EXCEPTION_INIT (resource_busy, -54);
5706:
5707: -- 2810346: Lock failed record details into log
5708: l_org_id mtl_system_items_interface.organization_id%TYPE;
5709: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;
5710:
5711: l_target_lc_id mtl_system_items_b.lifecycle_id%TYPE;
5712:
5713: BEGIN

Line 5711: l_target_lc_id mtl_system_items_b.lifecycle_id%TYPE;

5707: -- 2810346: Lock failed record details into log
5708: l_org_id mtl_system_items_interface.organization_id%TYPE;
5709: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;
5710:
5711: l_target_lc_id mtl_system_items_b.lifecycle_id%TYPE;
5712:
5713: BEGIN
5714: SAVEPOINT before_lock; -- Bug 5997870
5715: FOR rec IN C_lock_msi_records LOOP

Line 5894: FROM mtl_system_items_b i

5890: decode( rec.CUSTOMER_ORDER_FLAG, 'Y', 11, 0 )
5891: )
5892: and EXISTS
5893: ( SELECT 'x'
5894: FROM mtl_system_items_b i
5895: WHERE i.inventory_item_id = rec.inventory_item_id
5896: AND i.organization_id = p.organization_id
5897: )
5898: -- Check if the item already has any category assignment

Line 6001: UPDATE MTL_SYSTEM_ITEMS_B MTLSYSI

5997: );
5998:
5999: END IF;
6000:
6001: UPDATE MTL_SYSTEM_ITEMS_B MTLSYSI
6002: SET
6003: --* Modified l_sysdate => Nvl(rec.LAST_UPDATE_DATE,l_sysdate) for Bug - 3313863
6004: LAST_UPDATE_DATE = Nvl(rec.LAST_UPDATE_DATE,l_sysdate),
6005: LAST_UPDATED_BY = user_id,

Line 6402: update MTL_SYSTEM_ITEMS_TL

6398:
6399: --
6400: -- R11.5 MLS
6401: --
6402: update MTL_SYSTEM_ITEMS_TL
6403: set
6404: DESCRIPTION = rec.DESCRIPTION,
6405: LONG_DESCRIPTION = rec.LONG_DESCRIPTION,
6406: LAST_UPDATE_DATE = NVL(rec.LAST_UPDATE_DATE,l_sysdate),

Line 6448: update mtl_system_items_interface

6444:
6445: EXCEPTION
6446:
6447: when obj_version_error THEN -- bug 5870114
6448: update mtl_system_items_interface
6449: set process_flag = 3,
6450: request_id = req_id,
6451: PROGRAM_APPLICATION_ID = prg_appid,
6452: PROGRAM_ID = prg_id,

Line 6462: FROM mtl_system_items_interface

6458: -- Returning clause is commented and change to select clause a part of bug 5870114 as it was throwing TOO_MANY_RECORDS errors
6459:
6460: SELECT organization_id, transaction_id INTO
6461: l_org_id,l_transaction_id
6462: FROM mtl_system_items_interface
6463: WHERE inventory_item_id = item_rec.inventory_item_id
6464: and (set_process_id = xset_id or set_process_id = xset_id + 1000000000000)
6465: and process_flag = 3 AND ROWNUM=1;
6466:

Line 6477: 'MTL_SYSTEM_ITEMS',

6473: req_id,
6474: l_transaction_id,
6475: err_text,
6476: 'INVENTORY_ITEM_ID',
6477: 'MTL_SYSTEM_ITEMS',
6478: 'INV_IOI_RECORD_LOCKED',
6479: err_text);
6480: when resource_busy then
6481:

Line 6486: update mtl_system_items_interface

6482: -- 2810346: Lock failed record details into log
6483: -- Updating the interface records and then logging errors
6484: -- Earlier it was log and then update. Doing this to avoid a fetch.
6485:
6486: update mtl_system_items_interface
6487: set process_flag = 3,
6488: request_id = req_id,
6489: PROGRAM_APPLICATION_ID = prg_appid,
6490: PROGRAM_ID = prg_id,

Line 6499: FROM mtl_system_items_interface

6495: and process_flag = 4;
6496: --RETURNING organization_id,transaction_id INTO l_org_id,l_transaction_id;
6497:
6498: SELECT organization_id, transaction_id INTO l_org_id,l_transaction_id
6499: FROM mtl_system_items_interface
6500: WHERE inventory_item_id = item_rec.inventory_item_id
6501: and (set_process_id = xset_id or set_process_id = xset_id +1000000000000)
6502: and process_flag = 3 AND ROWNUM=1;
6503:

Line 6514: 'MTL_SYSTEM_ITEMS',

6510: req_id,
6511: l_transaction_id,
6512: err_text,
6513: 'INVENTORY_ITEM_ID',
6514: 'MTL_SYSTEM_ITEMS',
6515: 'INV_IOI_RECORD_LOCKED',
6516: err_text);
6517: /* commit for debugging ONLY */
6518: -- COMMIT;

Line 6546: UPDATE mtl_system_items_b

6542: INVPUTLI.info('INVUPD2B: Update: III' || item_csr.inventory_item_id ||
6543: 'segment1' || item_csr.segment1);
6544: END IF;
6545:
6546: UPDATE mtl_system_items_b
6547: SET segment1 = item_csr.segment1,
6548: segment2 = item_csr.segment2,
6549: segment3 = item_csr.segment3,
6550: segment4 = item_csr.segment4,

Line 6575: UPDATE MTL_SYSTEM_ITEMS_TL

6571: -- Start fix for bug 7017691 Issue #4 Move out of the C_msii_processed_records
6572: -- loop
6573: FOR cr IN c_ego_intf_rows LOOP
6574: INVPUTLI.info('Ego Intf Table has rows '||cr.language || ' ' ||cr.column_value);
6575: UPDATE MTL_SYSTEM_ITEMS_TL
6576: SET DESCRIPTION = NVL(cr.column_value, DESCRIPTION),
6577: LAST_UPDATE_DATE = l_sysdate,
6578: LAST_UPDATED_BY = user_id,
6579: LAST_UPDATE_LOGIN = login_id

Line 6642: l_org_id mtl_system_items_interface.organization_id%TYPE ;

6638: FOR UPDATE of revision_id;
6639:
6640: resource_busy EXCEPTION;
6641: PRAGMA EXCEPTION_INIT (resource_busy, -54);
6642: l_org_id mtl_system_items_interface.organization_id%TYPE ;
6643: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;
6644:
6645: BEGIN
6646:

Line 6643: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;

6639:
6640: resource_busy EXCEPTION;
6641: PRAGMA EXCEPTION_INIT (resource_busy, -54);
6642: l_org_id mtl_system_items_interface.organization_id%TYPE ;
6643: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;
6644:
6645: BEGIN
6646:
6647:

Line 6719: 'MTL_SYSTEM_ITEMS',

6715: req_id,
6716: l_transaction_id,
6717: err_text,
6718: 'INVENTORY_ITEM_ID',
6719: 'MTL_SYSTEM_ITEMS',
6720: 'INV_IOI_RECORD_LOCKED',
6721: err_text);
6722: WHEN OTHERS THEN
6723: --bug #4251913: Included SQLCODE and SQLERRM to trap exception messages.

Line 6742: table_name := 'MTL_SYSTEM_ITEMS_INTERFACE';

6738: --INVPUTLI.info('INVPPROC: Finished updating record in MSI with MSII record'|| xset_id);
6739:
6740: -- set process_flags to 7
6741:
6742: table_name := 'MTL_SYSTEM_ITEMS_INTERFACE';
6743: update MTL_SYSTEM_ITEMS_INTERFACE
6744: set process_flag = 7,
6745: request_id = req_id,
6746: PROGRAM_APPLICATION_ID = prg_appid,

Line 6743: update MTL_SYSTEM_ITEMS_INTERFACE

6739:
6740: -- set process_flags to 7
6741:
6742: table_name := 'MTL_SYSTEM_ITEMS_INTERFACE';
6743: update MTL_SYSTEM_ITEMS_INTERFACE
6744: set process_flag = 7,
6745: request_id = req_id,
6746: PROGRAM_APPLICATION_ID = prg_appid,
6747: PROGRAM_ID = prg_id,

Line 6808: update MTL_SYSTEM_ITEMS_INTERFACE

6804:
6805: IF l_inv_debug_level IN(101, 102) THEN
6806: INVPUTLI.info('INVUPD2B: Inside set_process_flag3');
6807: END IF;
6808: update MTL_SYSTEM_ITEMS_INTERFACE
6809: set PROCESS_FLAG = l_process_flag_3,
6810: request_id = reqst_id,
6811: PROGRAM_APPLICATION_ID = prog_appid,
6812: PROGRAM_ID = prog_id,