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.

APPS.INVUPD2B dependencies on MTL_SYSTEM_ITEMS

Line 345: MTL_SYSTEM_ITEMS_INTERFACE

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

Line 356: (select 1 from mtl_system_items_interface

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

Line 725: FROM mtl_system_items_interface

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

Line 746: update /+ first_rows index(MTL_SYSTEM_ITEMS_INTERFACE,MTL_SYSTEM_ITEMS_INTERFACE_N3) /

742: -- xset_id);
743:
744: --5351611
745: -- Bug 10404086 : Added below hint
746: update /*+ first_rows index(MTL_SYSTEM_ITEMS_INTERFACE,MTL_SYSTEM_ITEMS_INTERFACE_N3) */
747: mtl_system_items_interface
748: set set_process_id = xset_id + 1000000000000
749: where set_process_id = tmp_xset_id + 1000000000000 ; --5405867
750:

Line 747: mtl_system_items_interface

743:
744: --5351611
745: -- Bug 10404086 : Added below hint
746: update /*+ first_rows index(MTL_SYSTEM_ITEMS_INTERFACE,MTL_SYSTEM_ITEMS_INTERFACE_N3) */
747: mtl_system_items_interface
748: set set_process_id = xset_id + 1000000000000
749: where set_process_id = tmp_xset_id + 1000000000000 ; --5405867
750:
751: if (ret_code = 0) then

Line 752: update mtl_system_items_interface

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

Line 770: 'MTL_SYSTEM_ITEMS_INTERFACE',

766: request_id,
767: t_trans_id,
768: error_text,
769: null,
770: 'MTL_SYSTEM_ITEMS_INTERFACE',
771: 'INV_CHILD_VIOLATION_ERROR',
772: err_text);
773: dumm_status := INVUPD2B.set_process_flag3(rec.ROWID,user_id,login_id,prog_appid,prog_id,request_id);
774: end if;

Line 824: m_Item_rec MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;

820: 62, 65, 70, 80, 90, 100, 120, 130));
821:
822: l_Attribute_Code mtl_item_attributes.attribute_name%TYPE;
823: */
824: m_Item_rec MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;
825: l_Item_rec MTL_SYSTEM_ITEMS_VL%ROWTYPE;
826: l_create_child BOOLEAN := FALSE;
827:
828: BEGIN

Line 825: l_Item_rec MTL_SYSTEM_ITEMS_VL%ROWTYPE;

821:
822: l_Attribute_Code mtl_item_attributes.attribute_name%TYPE;
823: */
824: m_Item_rec MTL_SYSTEM_ITEMS_INTERFACE%ROWTYPE;
825: l_Item_rec MTL_SYSTEM_ITEMS_VL%ROWTYPE;
826: l_create_child BOOLEAN := FALSE;
827:
828: BEGIN
829:

Line 832: FROM mtl_system_items_interface

828: BEGIN
829:
830: INVPUTLI.info('INVUPD2 : Begin Check create auto child ' );
831: SELECT * INTO m_Item_rec
832: FROM mtl_system_items_interface
833: WHERE rowid = mast_rowid;
834:
835: SELECT * INTO l_Item_rec
836: FROM mtl_system_items_vl

Line 836: FROM mtl_system_items_vl

832: FROM mtl_system_items_interface
833: WHERE rowid = mast_rowid;
834:
835: SELECT * INTO l_Item_rec
836: FROM mtl_system_items_vl
837: WHERE inventory_item_id = item_id
838: AND organization_id = org_id;
839:
840:

Line 1465: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP

1461: CURSOR C_msi_child_records is
1462: select
1463: MSI.INVENTORY_ITEM_ID,
1464: MSI.ORGANIZATION_ID
1465: from MTL_SYSTEM_ITEMS_B MSI, MTL_PARAMETERS MP
1466: where MP.master_organization_id = org_id
1467: and MP.organization_id = MSI.organization_id
1468: and MSI.inventory_item_id = inv_item_id
1469: and MSI.organization_id <> MP.master_organization_id;

Line 1474: from MTL_SYSTEM_ITEMS_INTERFACE

1470:
1471: CURSOR C_msii_forupdate_records is
1472: select
1473: ROWID, ORGANIZATION_ID
1474: from MTL_SYSTEM_ITEMS_INTERFACE
1475: where SET_PROCESS_ID = xset_id + 1000000000000
1476: and PROCESS_FLAG = 4
1477: and INVENTORY_ITEM_ID = inv_item_id;
1478:

Line 1611: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE

1607: END IF;
1608: -- Insert msi data onto MSII for child record.
1609: -- Need to verify these attributes.
1610: --
1611: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE
1612: (
1613: TRANSACTION_ID,
1614: INVENTORY_ITEM_ID,
1615: ORGANIZATION_ID,

Line 2013: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,

2009: TRADE_ITEM_DESCRIPTOR,
2010: STYLE_ITEM_FLAG,
2011: STYLE_ITEM_ID)
2012: SELECT
2013: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL,
2014: inv_item_id,
2015: org_id,
2016: xset_id + 1000000000000,
2017: 'AUTO_CHILD',

Line 2412: MTL_SYSTEM_ITEMS_VL MSI

2408: MSI.TRADE_ITEM_DESCRIPTOR,
2409: MSI.STYLE_ITEM_FLAG,
2410: MSI.STYLE_ITEM_ID
2411: FROM
2412: MTL_SYSTEM_ITEMS_VL MSI
2413: WHERE
2414: MSI.inventory_item_id = inv_item_id
2415: AND MSI.organization_id = org_id;
2416:

Line 2455: msii_master_temp mtl_system_items_interface%ROWTYPE;

2451: IS
2452:
2453: -- temprec to hold master record data from msii
2454: --
2455: msii_master_temp mtl_system_items_interface%ROWTYPE;
2456:
2457: l_process_flag_2 NUMBER := 2;
2458:
2459: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

Line 2472: MTL_SYSTEM_ITEMS_INTERFACE MSII

2468: --
2469: select *
2470: into msii_master_temp
2471: from
2472: MTL_SYSTEM_ITEMS_INTERFACE MSII
2473: where
2474: MSII.ROWID = master_row_id;
2475:
2476: -- Update child record with master record data for attributes

Line 2479: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII

2475:
2476: -- Update child record with master record data for attributes
2477: -- under master control.
2478: --
2479: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
2480: 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 ),
2481: MSII.INVENTORY_ITEM_STATUS_CODE = decode( A_INVENTORY_ITEM_STATUS_CODE,1, msii_master_temp.INVENTORY_ITEM_STATUS_CODE,MSII.INVENTORY_ITEM_STATUS_CODE ),
2482: MSII.ITEM_TYPE = decode( A_ITEM_TYPE,1,msii_master_temp.ITEM_TYPE,MSII.ITEM_TYPE ),
2483: 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 3489: from MTL_SYSTEM_ITEMS_INTERFACE

3485: ROWID,
3486: INVENTORY_ITEM_ID,
3487: ORGANIZATION_ID,
3488: TRANSACTION_ID
3489: from MTL_SYSTEM_ITEMS_INTERFACE
3490: where process_flag = 4
3491: and set_process_id = xset_id
3492: and ((organization_id = org_id) or (all_org = 1))
3493: and organization_id in

Line 3558: msii_temp mtl_system_items_interface%ROWTYPE;

3554: request_id NUMBER := -1
3555: )
3556: RETURN INTEGER
3557: IS
3558: msii_temp mtl_system_items_interface%ROWTYPE;
3559: msi_temp mtl_system_items_b%ROWTYPE;
3560:
3561: dumm_status NUMBER;
3562: status NUMBER;

Line 3559: msi_temp mtl_system_items_b%ROWTYPE;

3555: )
3556: RETURN INTEGER
3557: IS
3558: msii_temp mtl_system_items_interface%ROWTYPE;
3559: msi_temp mtl_system_items_b%ROWTYPE;
3560:
3561: dumm_status NUMBER;
3562: status NUMBER;
3563:

Line 3647: from MTL_SYSTEM_ITEMS_INTERFACE MSII

3643:
3644: -- msii (updated to)
3645: select *
3646: into msii_temp
3647: from MTL_SYSTEM_ITEMS_INTERFACE MSII
3648: where MSII.rowid = row_id;
3649:
3650: -- msi (updated from)
3651: select *

Line 3653: from MTL_SYSTEM_ITEMS_B MSI

3649:
3650: -- msi (updated from)
3651: select *
3652: into msi_temp
3653: from MTL_SYSTEM_ITEMS_B MSI
3654: where MSI.organization_id = msii_temp.organization_id
3655: and msi.inventory_item_id = msii_temp.inventory_item_id ;
3656:
3657: select master_organization_id

Line 3978: 'MTL_SYSTEM_ITEMS_INTERFACE',

3974: request_id,
3975: trans_id,
3976: err_text,
3977: 'LOT_CONTROL_CODE',
3978: 'MTL_SYSTEM_ITEMS_INTERFACE',
3979: 'INV_LOT_QOH_CANNOT_UPDATE',
3980: err_text);
3981:
3982: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 3996: 'MTL_SYSTEM_ITEMS_INTERFACE',

3992: request_id,
3993: trans_id,
3994: err_text,
3995: 'LOT_CONTROL_CODE',
3996: 'MTL_SYSTEM_ITEMS_INTERFACE',
3997: 'INV_PENDING_ADJUSTMENT',
3998: err_text);
3999:
4000: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4014: 'MTL_SYSTEM_ITEMS_INTERFACE',

4010: request_id,
4011: trans_id,
4012: err_text,
4013: 'LOT_CONTROL_CODE',
4014: 'MTL_SYSTEM_ITEMS_INTERFACE',
4015: 'INV_INTRANSIT_CANNOT_UPDATE',
4016: err_text);
4017:
4018: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4031: 'MTL_SYSTEM_ITEMS_INTERFACE',

4027: request_id,
4028: trans_id,
4029: err_text,
4030: 'LOT_CONTROL_CODE',
4031: 'MTL_SYSTEM_ITEMS_INTERFACE',
4032: 'INV_DELIVER_CANNOT_UPDATE',
4033: err_text);
4034:
4035: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4050: 'MTL_SYSTEM_ITEMS_INTERFACE',

4046: request_id,
4047: trans_id,
4048: err_text,
4049: 'LOT_CONTROL_CODE',
4050: 'MTL_SYSTEM_ITEMS_INTERFACE',
4051: 'INV_RECORG_SHIPSUPP_RO_LOT',
4052: err_text);
4053:
4054: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4067: 'MTL_SYSTEM_ITEMS_INTERFACE',

4063: request_id,
4064: trans_id,
4065: err_text,
4066: 'SERIAL_NUMBER_CONTROL_CODE',
4067: 'MTL_SYSTEM_ITEMS_INTERFACE',
4068: 'INV_RECORG_SHIPSUPP_RO_SERL',
4069: err_text);
4070:
4071: 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: 'CHILD_LOT_FLAG',
4089: 'MTL_SYSTEM_ITEMS_INTERFACE',
4090: 'INV_LOT_QOH_CANNOT_UPDATE',
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: 'CHILD_LOT_FLAG',
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 4127: 'MTL_SYSTEM_ITEMS_INTERFACE',

4123: request_id,
4124: trans_id,
4125: err_text,
4126: 'GRADE_CONTROL_FLAG',
4127: 'MTL_SYSTEM_ITEMS_INTERFACE',
4128: 'INV_LOT_QOH_CANNOT_UPDATE',
4129: err_text);
4130:
4131: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4144: 'MTL_SYSTEM_ITEMS_INTERFACE',

4140: request_id,
4141: trans_id,
4142: err_text,
4143: 'GRADE_CONTROL_FLAG',
4144: 'MTL_SYSTEM_ITEMS_INTERFACE',
4145: 'INV_PENDING_ADJUSTMENT',
4146: err_text);
4147:
4148: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4165: 'MTL_SYSTEM_ITEMS_INTERFACE',

4161: request_id,
4162: trans_id,
4163: err_text,
4164: 'LOT_DIVISIBLE_FLAG',
4165: 'MTL_SYSTEM_ITEMS_INTERFACE',
4166: 'INV_LOT_QOH_CANNOT_UPDATE',
4167: err_text);
4168:
4169: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4182: 'MTL_SYSTEM_ITEMS_INTERFACE',

4178: request_id,
4179: trans_id,
4180: err_text,
4181: 'LOT_DIVISIBLE_FLAG',
4182: 'MTL_SYSTEM_ITEMS_INTERFACE',
4183: 'INV_PENDING_ADJUSTMENT',
4184: err_text);
4185:
4186: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4210: 'MTL_SYSTEM_ITEMS_INTERFACE',

4206: request_id,
4207: trans_id,
4208: err_text,
4209: 'SHELF_LIFE_CODE',
4210: 'MTL_SYSTEM_ITEMS_INTERFACE',
4211: 'INV_LOT_QOH_CANNOT_UPDATE',
4212: err_text);
4213:
4214: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4234: 'MTL_SYSTEM_ITEMS_INTERFACE',

4230: request_id,
4231: trans_id,
4232: err_text,
4233: 'LOCATION_CONTROL_CODE',
4234: 'MTL_SYSTEM_ITEMS_INTERFACE',
4235: 'INV_LOC_CONTROL_CODE_ERR',
4236: err_text);
4237:
4238: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4251: 'MTL_SYSTEM_ITEMS_INTERFACE',

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

Line 4275: 'MTL_SYSTEM_ITEMS_INTERFACE',

4271: request_id,
4272: trans_id,
4273: err_text,
4274: 'RESERVABLE_TYPE',
4275: 'MTL_SYSTEM_ITEMS_INTERFACE',
4276: 'INV_RESERVABLE_TYPE_ERR',
4277: err_text);
4278:
4279: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4298: 'MTL_SYSTEM_ITEMS_INTERFACE',

4294: request_id,
4295: trans_id,
4296: err_text,
4297: 'RESERVABLE_TYPE',
4298: 'MTL_SYSTEM_ITEMS_INTERFACE',
4299: 'INV_RESERVABLE_NO_YES',
4300: err_text);
4301: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4302: end if;

Line 4326: 'MTL_SYSTEM_ITEMS_INTERFACE',

4322: request_id,
4323: trans_id,
4324: err_text,
4325: 'TRANSACTIONS_ENABLED_FLAG',
4326: 'MTL_SYSTEM_ITEMS_INTERFACE',
4327: 'INV_TRANSACTABLE_YES_NO',
4328: err_text);
4329: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4330: end if;

Line 4353: 'MTL_SYSTEM_ITEMS_INTERFACE',

4349: request_id,
4350: trans_id,
4351: err_text,
4352: 'SHIPPABLE_ITEM_FLAG',
4353: 'MTL_SYSTEM_ITEMS_INTERFACE',
4354: 'INV_OPEN_SO',
4355: err_text);
4356: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4357: elsif (msi_temp.SHIPPABLE_ITEM_FLAG = 'N' ) and (msii_temp.SHIPPABLE_ITEM_FLAG = 'Y') then

Line 4370: 'MTL_SYSTEM_ITEMS_INTERFACE',

4366: request_id,
4367: trans_id,
4368: err_text,
4369: 'SHIPPABLE_ITEM_FLAG',
4370: 'MTL_SYSTEM_ITEMS_INTERFACE',
4371: 'INV_TRANSACTABLE_NO_YES',
4372: err_text);
4373: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4374: end if;

Line 4396: 'MTL_SYSTEM_ITEMS_INTERFACE',

4392: request_id,
4393: trans_id,
4394: err_text,
4395: 'REPLENISH_TO_ORDER_FLAG',
4396: 'MTL_SYSTEM_ITEMS_INTERFACE',
4397: 'INV_ATO_YES_NO',
4398: err_text);
4399: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4400: end if;

Line 4418: 'MTL_SYSTEM_ITEMS_INTERFACE',

4414: request_id,
4415: trans_id,
4416: err_text,
4417: 'REVISION_QTY_CONTROL_CODE',
4418: 'MTL_SYSTEM_ITEMS_INTERFACE',
4419: 'INV_REV_QTY_CNTRL_CODE_ERR',
4420: err_text);
4421:
4422: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4435: 'MTL_SYSTEM_ITEMS_INTERFACE',

4431: request_id,
4432: trans_id,
4433: err_text,
4434: 'REVISION_QTY_CONTROL_CODE',
4435: 'MTL_SYSTEM_ITEMS_INTERFACE',
4436: 'INV_DELIVER_CANNOT_UPDATE',
4437: err_text);
4438: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4439: /*Bug 6501149 Code ends */

Line 4453: 'MTL_SYSTEM_ITEMS_INTERFACE',

4449: request_id,
4450: trans_id,
4451: err_text,
4452: 'REVISION_QTY_CONTROL_CODE',
4453: 'MTL_SYSTEM_ITEMS_INTERFACE',
4454: 'INV_PENDING_ADJUSTMENT',
4455: err_text);
4456:
4457: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4484: 'MTL_SYSTEM_ITEMS_INTERFACE',

4480: request_id,
4481: trans_id,
4482: err_text,
4483: 'SERIAL_NUMBER_CONTROL_CODE',
4484: 'MTL_SYSTEM_ITEMS_INTERFACE',
4485: 'INV_QTY_ON_HAND',
4486: err_text);
4487: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4488: elsif (msi_temp.SERIAL_NUMBER_CONTROL_CODE = 1 and

Line 4503: 'MTL_SYSTEM_ITEMS_INTERFACE',

4499: request_id,
4500: trans_id,
4501: err_text,
4502: 'SERIAL_NUMBER_CONTROL_CODE',
4503: 'MTL_SYSTEM_ITEMS_INTERFACE',
4504: 'INV_SERIAL_NO_YES',
4505: err_text);
4506: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4507: end if;

Line 4526: 'MTL_SYSTEM_ITEMS_INTERFACE',

4522: request_id,
4523: trans_id,
4524: err_text,
4525: 'SERIAL_NUMBER_CONTROL_CODE',
4526: 'MTL_SYSTEM_ITEMS_INTERFACE',
4527: 'INV_INTRANSIT_CANNOT_UPDATE',
4528: err_text);
4529:
4530: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4548: 'MTL_SYSTEM_ITEMS_INTERFACE',

4544: request_id,
4545: trans_id,
4546: err_text,
4547: 'SERIAL_NUMBER_CONTROL_CODE',
4548: 'MTL_SYSTEM_ITEMS_INTERFACE',
4549: 'INV_DELIVER_CANNOT_UPDATE',
4550: err_text);
4551: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4552: /* Bug 6501149 Code ended */

Line 4571: 'MTL_SYSTEM_ITEMS_INTERFACE',

4567: request_id,
4568: trans_id,
4569: err_text,
4570: 'BOM_ENABLED_FLAG',
4571: 'MTL_SYSTEM_ITEMS_INTERFACE',
4572: 'INV_BOM_ENABLED_FLAG_ERR',
4573: err_text);
4574:
4575: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4596: 'MTL_SYSTEM_ITEMS_INTERFACE',

4592: request_id,
4593: trans_id,
4594: err_text,
4595: 'BOM_ITEM_TYPE',
4596: 'MTL_SYSTEM_ITEMS_INTERFACE',
4597: 'INV_BOM_ITEM_TYPE_ERR1',
4598: err_text);
4599:
4600: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4616: 'MTL_SYSTEM_ITEMS_INTERFACE',

4612: request_id,
4613: trans_id,
4614: err_text,
4615: 'BOM_ENABLED_FLAG',
4616: 'MTL_SYSTEM_ITEMS_INTERFACE',
4617: 'INV_IOI_ITEM_BOM_EXISTS',
4618: err_text);
4619:
4620: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4652: 'MTL_SYSTEM_ITEMS_INTERFACE',

4648: request_id,
4649: trans_id,
4650: err_text,
4651: 'BOM_ITEM_TYPE',
4652: 'MTL_SYSTEM_ITEMS_INTERFACE',
4653: 'INV_BOM_ITEM_TYPE_ERR2',
4654: err_text);
4655:
4656: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4677: 'MTL_SYSTEM_ITEMS_INTERFACE',

4673: request_id,
4674: trans_id,
4675: err_text,
4676: 'BOM_ITEM_TYPE',
4677: 'MTL_SYSTEM_ITEMS_INTERFACE',
4678: 'INV_BOM_ITEM_TYPE_ERR3',
4679: err_text);
4680:
4681: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4713: 'MTL_SYSTEM_ITEMS_INTERFACE',

4709: request_id,
4710: trans_id,
4711: err_text,
4712: 'PICK_COMPONENTS_FLAG',
4713: 'MTL_SYSTEM_ITEMS_INTERFACE',
4714: 'INV_ITEM_LOT_COMP',
4715: err_text);
4716: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
4717: END IF;

Line 4738: 'MTL_SYSTEM_ITEMS_INTERFACE',

4734: request_id,
4735: trans_id,
4736: err_text,
4737: 'COSTING_ENABLED_FLAG',
4738: 'MTL_SYSTEM_ITEMS_INTERFACE',
4739: 'INV_COSTING_ENABLED_FLAG_ERR',
4740: err_text);
4741:
4742: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4753: from mtl_item_attributes where attribute_name = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG';

4749: (cost_txn = 2) then
4750:
4751: select control_level
4752: into costing_level
4753: from mtl_item_attributes where attribute_name = 'MTL_SYSTEM_ITEMS.COSTING_ENABLED_FLAG';
4754:
4755: IF (costing_level = 1) then
4756: dumm_status := INVPUOPI.mtl_log_interface_err(
4757: org_id,

Line 4766: 'MTL_SYSTEM_ITEMS_INTERFACE',

4762: request_id,
4763: trans_id,
4764: err_text,
4765: 'COSTING_ENABLED_FLAG',
4766: 'MTL_SYSTEM_ITEMS_INTERFACE',
4767: 'INV_COSTING_ENABLED_FLAG_ERR',
4768: err_text);
4769:
4770: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4792: 'MTL_SYSTEM_ITEMS_INTERFACE',

4788: request_id,
4789: trans_id,
4790: err_text,
4791: 'INVENTORY_ASSET_FLAG',
4792: 'MTL_SYSTEM_ITEMS_INTERFACE',
4793: 'INV_INVENTORY_ASSET_FLAG_ERR',
4794: err_text);
4795:
4796: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4807: from mtl_item_attributes where attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG';

4803: (cost_txn = 2) then
4804:
4805: select control_level
4806: into invetory_asset_flag_level
4807: from mtl_item_attributes where attribute_name = 'MTL_SYSTEM_ITEMS.INVENTORY_ASSET_FLAG';
4808:
4809: IF (invetory_asset_flag_level = 1) then
4810: dumm_status := INVPUOPI.mtl_log_interface_err(
4811: org_id,

Line 4820: 'MTL_SYSTEM_ITEMS_INTERFACE',

4816: request_id,
4817: trans_id,
4818: err_text,
4819: 'INVENTORY_ASSET_FLAG',
4820: 'MTL_SYSTEM_ITEMS_INTERFACE',
4821: 'INV_INVENTORY_ASSET_FLAG_ERR',
4822: err_text);
4823:
4824: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4844: 'MTL_SYSTEM_ITEMS_INTERFACE',

4840: request_id,
4841: trans_id,
4842: err_text,
4843: 'FIXED_ORDER_QUANTITY',
4844: 'MTL_SYSTEM_ITEMS_INTERFACE',
4845: 'INV_FIXED_ORDER_QUANTITY_ERR',
4846: err_text);
4847:
4848: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4867: 'MTL_SYSTEM_ITEMS_INTERFACE',

4863: request_id,
4864: trans_id,
4865: err_text,
4866: 'PLANNING_MAKE_BUY_CODE',
4867: 'MTL_SYSTEM_ITEMS_INTERFACE',
4868: 'INV_PLANNING_MAKE_BUY_CODE',
4869: err_text);
4870:
4871: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4889: 'MTL_SYSTEM_ITEMS_INTERFACE',

4885: request_id,
4886: trans_id,
4887: err_text,
4888: 'ACCEPTABLE_EARLY_DAYS',
4889: 'MTL_SYSTEM_ITEMS_INTERFACE',
4890: 'INV_ACCEPTABLE_EARLY_DAYS_ERR',
4891: err_text);
4892:
4893: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4911: 'MTL_SYSTEM_ITEMS_INTERFACE',

4907: request_id,
4908: trans_id,
4909: err_text,
4910: 'ACCEPTABLE_RATE_INCREASE',
4911: 'MTL_SYSTEM_ITEMS_INTERFACE',
4912: 'INV_ACCEPT_RATE_INCREASE_ERR',
4913: err_text);
4914:
4915: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4933: 'MTL_SYSTEM_ITEMS_INTERFACE',

4929: request_id,
4930: trans_id,
4931: err_text,
4932: 'ACCEPTABLE_RATE_DECREASE',
4933: 'MTL_SYSTEM_ITEMS_INTERFACE',
4934: 'INV_ACCEPT_RATE_DECREASE_ERR',
4935: err_text);
4936:
4937: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4956: 'MTL_SYSTEM_ITEMS_INTERFACE',

4952: request_id,
4953: trans_id,
4954: err_text,
4955: 'DEMAND_TIME_FENCE_DAYS',
4956: 'MTL_SYSTEM_ITEMS_INTERFACE',
4957: 'INV_DEMAND_TIME_FENCE_DAYS_ERR',
4958: err_text);
4959:
4960: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 4979: 'MTL_SYSTEM_ITEMS_INTERFACE',

4975: request_id,
4976: trans_id,
4977: err_text,
4978: 'PLANNING_TIME_FENCE_DAYS',
4979: 'MTL_SYSTEM_ITEMS_INTERFACE',
4980: 'INV_PLAN_TIME_FENCE_DAYS_ERR',
4981: err_text);
4982:
4983: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5002: 'MTL_SYSTEM_ITEMS_INTERFACE',

4998: request_id,
4999: trans_id,
5000: err_text,
5001: 'REPETITIVE_PLANNING_FLAG',
5002: 'MTL_SYSTEM_ITEMS_INTERFACE',
5003: 'INV_REPET_PLANNING_FLAG_ERR',
5004: err_text);
5005:
5006: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5026: 'MTL_SYSTEM_ITEMS_INTERFACE',

5022: request_id,
5023: trans_id,
5024: err_text,
5025: 'SHRINKAGE_RATE',
5026: 'MTL_SYSTEM_ITEMS_INTERFACE',
5027: 'INV_SHRINKAGE_RATE_ERR',
5028: err_text);
5029:
5030: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5050: 'MTL_SYSTEM_ITEMS_INTERFACE',

5046: request_id,
5047: trans_id,
5048: err_text,
5049: 'FULL_LEAD_TIME',
5050: 'MTL_SYSTEM_ITEMS_INTERFACE',
5051: 'INV_FULL_LEAD_TIME_ERR',
5052: err_text);
5053:
5054: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5062: UPDATE mtl_system_items_interface

5058: -- validate LEAD_TIME_LOT_SIZE
5059: -- if null, set to std_lot_size
5060:
5061: if (msii_temp.lead_time_lot_size IS null) then
5062: UPDATE mtl_system_items_interface
5063: SET lead_time_lot_size = msii_temp.std_lot_size
5064: WHERE rowid = row_id;
5065:
5066: /* commit for debugging ONLY */

Line 5088: 'MTL_SYSTEM_ITEMS_INTERFACE',

5084: request_id,
5085: trans_id,
5086: err_text,
5087: 'POSTPROCESSING_LEAD_TIME',
5088: 'MTL_SYSTEM_ITEMS_INTERFACE',
5089: 'INV_POSTPROC_LEAD_TIME_ERR',
5090: err_text);
5091:
5092: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5110: 'MTL_SYSTEM_ITEMS_INTERFACE',

5106: request_id,
5107: trans_id,
5108: err_text,
5109: 'VARIABLE_LEAD_TIME',
5110: 'MTL_SYSTEM_ITEMS_INTERFACE',
5111: 'INV_VARIABLE_LEAD_TIME_ERR',
5112: err_text);
5113:
5114: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5129: 'MTL_SYSTEM_ITEMS_INTERFACE',

5125: request_id,
5126: trans_id,
5127: err_text,
5128: 'EFFECTIVITY_CONTROL',
5129: 'MTL_SYSTEM_ITEMS_INTERFACE',
5130: 'ITM-EFFC-ITEM IS BILL OR COMP',
5131: err_text);
5132:
5133: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5154: 'MTL_SYSTEM_ITEMS_INTERFACE',

5150: request_id,
5151: trans_id,
5152: err_text,
5153: 'BUILD_IN_WIP_FLAG',
5154: 'MTL_SYSTEM_ITEMS_INTERFACE',
5155: 'INV_BUILD_IN_WIP_FLAG_ERR',
5156: err_text);
5157:
5158: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5177: 'MTL_SYSTEM_ITEMS_INTERFACE',

5173: request_id,
5174: trans_id,
5175: err_text,
5176: 'SERVICE_ITEM_FLAG',
5177: 'MTL_SYSTEM_ITEMS_INTERFACE',
5178: 'INV_SERVICE_ITEM_FLAG_ERR',
5179: err_text);
5180:
5181: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5199: 'MTL_SYSTEM_ITEMS_INTERFACE',

5195: request_id,
5196: trans_id,
5197: err_text,
5198: 'SERVICE_STARTING_DELAY',
5199: 'MTL_SYSTEM_ITEMS_INTERFACE',
5200: 'INV_SERVICE_STARTING_DELAY_ERR',
5201: err_text);
5202:
5203: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5220: 'MTL_SYSTEM_ITEMS_INTERFACE',

5216: request_id,
5217: trans_id,
5218: err_text,
5219: 'VEHICLE_ITEM_FLAG',
5220: 'MTL_SYSTEM_ITEMS_INTERFACE',
5221: 'INV_VEHICLE_CANNOT_UPDATE',
5222: err_text);
5223:
5224: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5241: 'MTL_SYSTEM_ITEMS_INTERFACE',

5237: request_id,
5238: trans_id,
5239: err_text,
5240: 'COMMS_NL_TRACKABLE_FLAG',
5241: 'MTL_SYSTEM_ITEMS_INTERFACE',
5242: 'INV_ONHAND_TRACKABLE_EXIST',
5243: err_text);
5244:
5245: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5266: 'MTL_SYSTEM_ITEMS_INTERFACE',

5262: request_id,
5263: trans_id,
5264: err_text,
5265: 'STOCK_ENABLED_FLAG',
5266: 'MTL_SYSTEM_ITEMS_INTERFACE',
5267: 'INV_DELIVER_CANNOT_UPDATE',
5268: err_text);
5269: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5270: end if;

Line 5286: 'MTL_SYSTEM_ITEMS_INTERFACE',

5282: request_id,
5283: trans_id,
5284: err_text,
5285: 'STOCK_ENABLED_FLAG',
5286: 'MTL_SYSTEM_ITEMS_INTERFACE',
5287: 'INV_PENDING_ADJUSTMENT',
5288: err_text);
5289: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5290: end if;

Line 5324: 'MTL_SYSTEM_ITEMS_INTERFACE',

5320: request_id,
5321: trans_id,
5322: err_text,
5323: l_column_name,
5324: 'MTL_SYSTEM_ITEMS_INTERFACE',
5325: 'INV_VMI_ENABLED_ITEM',
5326: err_text);
5327: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5328: end if;

Line 5350: 'MTL_SYSTEM_ITEMS_INTERFACE',

5346: request_id,
5347: trans_id,
5348: err_text,
5349: 'TRACKING_QUANTITY_IND',
5350: 'MTL_SYSTEM_ITEMS_INTERFACE',
5351: 'INV_QOH_CANNOT_UPDATE',
5352: err_text);
5353:
5354: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5370: 'MTL_SYSTEM_ITEMS_INTERFACE',

5366: request_id,
5367: trans_id,
5368: err_text,
5369: 'TRACKING_QUANTITY_IND',
5370: 'MTL_SYSTEM_ITEMS_INTERFACE',
5371: 'INV_PENDING_ADJUSTMENT',
5372: err_text);
5373:
5374: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5394: 'MTL_SYSTEM_ITEMS_INTERFACE',

5390: request_id,
5391: trans_id,
5392: err_text,
5393: 'SECONDARY_UOM_CODE',
5394: 'MTL_SYSTEM_ITEMS_INTERFACE',
5395: 'INV_QOH_CANNOT_UPDATE',
5396: err_text);
5397:
5398: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5414: 'MTL_SYSTEM_ITEMS_INTERFACE',

5410: request_id,
5411: trans_id,
5412: err_text,
5413: 'SECONDARY_UOM_CODE',
5414: 'MTL_SYSTEM_ITEMS_INTERFACE',
5415: 'INV_PENDING_ADJUSTMENT',
5416: err_text);
5417:
5418: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5438: 'MTL_SYSTEM_ITEMS_INTERFACE',

5434: request_id,
5435: trans_id,
5436: err_text,
5437: 'SECONDARY_DEFAULT_IND',
5438: 'MTL_SYSTEM_ITEMS_INTERFACE',
5439: 'INV_QOH_CANNOT_UPDATE',
5440: err_text);
5441:
5442: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5458: 'MTL_SYSTEM_ITEMS_INTERFACE',

5454: request_id,
5455: trans_id,
5456: err_text,
5457: 'SECONDARY_DEFAULT_IND',
5458: 'MTL_SYSTEM_ITEMS_INTERFACE',
5459: 'INV_PENDING_ADJUSTMENT',
5460: err_text);
5461:
5462: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5482: 'MTL_SYSTEM_ITEMS_INTERFACE',

5478: request_id,
5479: trans_id,
5480: err_text,
5481: 'PRIMARY_UOM_CODE',
5482: 'MTL_SYSTEM_ITEMS_INTERFACE',
5483: 'INV_QOH_CANNOT_UPDATE',
5484: err_text);
5485:
5486: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5502: 'MTL_SYSTEM_ITEMS_INTERFACE',

5498: request_id,
5499: trans_id,
5500: err_text,
5501: 'PRIMARY_UOM_CODE',
5502: 'MTL_SYSTEM_ITEMS_INTERFACE',
5503: 'INV_PENDING_ADJUSTMENT',
5504: err_text);
5505:
5506: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5526: 'MTL_SYSTEM_ITEMS_INTERFACE',

5522: request_id,
5523: trans_id,
5524: err_text,
5525: 'DUAL_UOM_DEVIATION_HIGH',
5526: 'MTL_SYSTEM_ITEMS_INTERFACE',
5527: 'INV_QOH_CANNOT_UPDATE',
5528: err_text);
5529:
5530: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5546: 'MTL_SYSTEM_ITEMS_INTERFACE',

5542: request_id,
5543: trans_id,
5544: err_text,
5545: 'DUAL_UOM_DEVIATION_HIGH',
5546: 'MTL_SYSTEM_ITEMS_INTERFACE',
5547: 'INV_PENDING_ADJUSTMENT',
5548: err_text);
5549:
5550: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5570: 'MTL_SYSTEM_ITEMS_INTERFACE',

5566: request_id,
5567: trans_id,
5568: err_text,
5569: 'DUAL_UOM_DEVIATION_LOW',
5570: 'MTL_SYSTEM_ITEMS_INTERFACE',
5571: 'INV_QOH_CANNOT_UPDATE',
5572: err_text);
5573:
5574: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5590: 'MTL_SYSTEM_ITEMS_INTERFACE',

5586: request_id,
5587: trans_id,
5588: err_text,
5589: 'DUAL_UOM_DEVIATION_LOW',
5590: 'MTL_SYSTEM_ITEMS_INTERFACE',
5591: 'INV_PENDING_ADJUSTMENT',
5592: err_text);
5593:
5594: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);

Line 5613: 'MTL_SYSTEM_ITEMS_INTERFACE',

5609: request_id,
5610: trans_id,
5611: err_text,
5612: 'RECIPE_ENABLED_FLAG',
5613: 'MTL_SYSTEM_ITEMS_INTERFACE',
5614: 'INV_RECIPE_ENABLED_FLAG_ERR',
5615: err_text);
5616: dumm_status := INVUPD2B.set_process_flag3(row_id,user_id,login_id,prog_appid,prog_id,request_id);
5617: END IF;

Line 5659: FROM MTL_SYSTEM_ITEMS_INTERFACE msii

5655: --Fix bug 6974062(7442071,7001285)
5656: CURSOR C_msii_processed_records
5657: IS
5658: SELECT distinct msii.inventory_item_id
5659: FROM MTL_SYSTEM_ITEMS_INTERFACE msii
5660: WHERE
5661: ( set_process_id = xset_id OR
5662: set_process_id = xset_id + 1000000000000 )
5663: AND transaction_type IN ('UPDATE', 'AUTO_CHILD')

Line 5669: FROM MTL_SYSTEM_ITEMS_INTERFACE msii

5665:
5666: CURSOR C_msii_processed_records_dup
5667: IS
5668: SELECT distinct msii.inventory_item_id, organization_id, item_number
5669: FROM MTL_SYSTEM_ITEMS_INTERFACE msii
5670: WHERE
5671: ( set_process_id = xset_id OR
5672: set_process_id = xset_id + 1000000000000 )
5673: AND transaction_type IN ('UPDATE', 'AUTO_CHILD')

Line 5697: , mtl_system_items_interface msii

5693: , muom.base_uom_flag
5694: , muom.uom_class UOMCL
5695: FROM
5696: mtl_units_of_measure_vl muom
5697: , mtl_system_items_interface msii
5698: WHERE
5699: msii.process_flag = 4
5700: AND msii.allowed_units_lookup_code = 1
5701: AND(msii.set_process_id = xset_id OR

Line 5718: FROM mtl_system_items_interface msii,

5714: tl.language,
5715: tl.column_value,
5716: msii.inventory_item_id,
5717: msii.organization_id
5718: FROM mtl_system_items_interface msii,
5719: ego_interface_tl tl,
5720: mtl_system_items item
5721: WHERE item.inventory_item_id = msii.inventory_item_id
5722: AND item.organization_id = msii.organization_id

Line 5720: mtl_system_items item

5716: msii.inventory_item_id,
5717: msii.organization_id
5718: FROM mtl_system_items_interface msii,
5719: ego_interface_tl tl,
5720: mtl_system_items item
5721: WHERE item.inventory_item_id = msii.inventory_item_id
5722: AND item.organization_id = msii.organization_id
5723: AND msii.transaction_type in ('UPDATE','AUTO_CHILD')
5724: AND msii.process_flag = 4

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

5724: AND msii.process_flag = 4
5725: AND (msii.set_process_id = xset_id or msii.set_process_id = xset_id + 1000000000000)
5726: AND tl.unique_id = msii.transaction_id
5727: AND tl.set_process_id = msii.set_process_id
5728: AND UPPER(tl.table_name) = 'MTL_SYSTEM_ITEMS_INTERFACE'
5729: AND UPPER(tl.column_name) = 'DESCRIPTION'
5730: AND tl.language IN (SELECT l.language_code FROM fnd_languages l
5731: WHERE l.installed_flag IN ('I', 'B'));
5732:

Line 5747: FROM MTL_SYSTEM_ITEMS_INTERFACE

5743: -- Start fix for bug 7017691(7435552,7147893) Issue #2 Replacing COUNT(*) with CURSOR
5744: CURSOR c_duplicate_check(p_set_id NUMBER, p_inventory_item_id NUMBER,
5745: p_organization_id NUMBER) IS
5746: SELECT 1
5747: FROM MTL_SYSTEM_ITEMS_INTERFACE
5748: WHERE inventory_item_id = p_inventory_item_id
5749: AND organization_id = p_organization_id
5750: AND process_flag = 4
5751: AND set_process_id = p_set_id

Line 5764: FROM mtl_system_items_b_kfv msik,

5760: msii.segment1,msii.segment2,msii.segment3,msii.segment4,msii.segment5,
5761: msii.segment6,msii.segment7,msii.segment8,msii.segment9,msii.segment10,
5762: msii.segment11,msii.segment12,msii.segment13,msii.segment14,msii.segment15,
5763: msii.segment16,msii.segment17,msii.segment18,msii.segment19,msii.segment20
5764: FROM mtl_system_items_b_kfv msik,
5765: mtl_system_items_interface msii,
5766: mtl_parameters mp
5767: WHERE msii.set_process_id = xset_id
5768: AND msii.transaction_type = 'UPDATE'

Line 5765: mtl_system_items_interface msii,

5761: msii.segment6,msii.segment7,msii.segment8,msii.segment9,msii.segment10,
5762: msii.segment11,msii.segment12,msii.segment13,msii.segment14,msii.segment15,
5763: msii.segment16,msii.segment17,msii.segment18,msii.segment19,msii.segment20
5764: FROM mtl_system_items_b_kfv msik,
5765: mtl_system_items_interface msii,
5766: mtl_parameters mp
5767: WHERE msii.set_process_id = xset_id
5768: AND msii.transaction_type = 'UPDATE'
5769: AND msii.process_flag = 4

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

5774: AND msii.item_number <> msik.concatenated_segments
5775: AND msik.concatenated_segments IS NOT NULL;
5776: -- End fix for bug 7017691 Issue #3
5777:
5778: TYPE transaction_type IS TABLE OF mtl_system_items_interface.transaction_id%TYPE
5779: INDEX BY BINARY_INTEGER;
5780: /* bug 10064010 as no case of delete will be there in update case
5781: --serial_tagging enh -- bug 9913552
5782:

Line 5785: FROM MTL_SYSTEM_ITEMS_INTERFACE

5781: --serial_tagging enh -- bug 9913552
5782:
5783: CURSOR serial_tag_del IS
5784: SELECT inventory_item_id,organization_id
5785: FROM MTL_SYSTEM_ITEMS_INTERFACE
5786: where process_flag <> 4
5787: and transaction_type in ('UPDATE','AUTO_CHILD')
5788: and (set_process_id = xset_id or set_process_id = xset_id + 1000000000000);
5789: */

Line 5796: FROM MTL_SYSTEM_ITEMS_INTERFACE

5792: /* Fix for bug 11654417 - In the below cursor, modified the
5793: filter on template_id to exclude both -1 and FND_API.G_MISS_NUM */
5794: CURSOR copy_assignment_frm_temp IS
5795: SELECT inventory_item_id,organization_id,template_id
5796: FROM MTL_SYSTEM_ITEMS_INTERFACE
5797: where process_flag =4
5798: and transaction_type in ('UPDATE','AUTO_CHILD')
5799: AND template_id IS NOT NULL
5800: AND template_id NOT IN (-1,FND_API.G_MISS_NUM)

Line 5900: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

5896: CLOSE c_duplicate_check;
5897: -- End Fix for bug 7017691 Issue #2
5898:
5899: IF ext_flag > 1 THEN
5900: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
5901: SET process_flag = 3
5902: WHERE inventory_item_id = item_rec.inventory_item_id
5903: AND organization_id = item_rec.organization_id
5904: AND process_flag = 4

Line 5930: 'MTL_SYSTEM_ITEMS_INTERFACE',

5926: req_id,
5927: transaction_table(j),
5928: error_msg,
5929: 'INVENTORY_ITEM_ID',
5930: 'MTL_SYSTEM_ITEMS_INTERFACE',
5931: 'INV_IOI_ERR_DPLC_REC_MSII_03', --bug 11894684, replace INV_IOI_ERR
5932: err_text);
5933: END LOOP;
5934: END IF;

Line 5986: select /+ first_rows index(MSII, MTL_SYSTEM_ITEMS_INTERFACE_N1) /

5982: DECLARE
5983:
5984: CURSOR C_lock_msi_records
5985: IS
5986: select /*+ first_rows index(MSII, MTL_SYSTEM_ITEMS_INTERFACE_N1) */
5987: msi.ROWID msi_rowid,
5988: msi.inventory_item_status_code msi_status_code,
5989: msi.lifecycle_id msi_lifecycle_id,
5990: msi.current_phase_id msi_current_phase_id,

Line 6007: from MTL_SYSTEM_ITEMS_B msi, MTL_SYSTEM_ITEMS_INTERFACE msii

6003: msi.CONTRACT_ITEM_TYPE_CODE contract_type,
6004: msi.INVENTORY_ASSET_FLAG inv_asset_flag,--Bug:3899614
6005: msi.OBJECT_VERSION_NUMBER obj_ver_num,
6006: msii.ROWID msii_rowid, msii.*
6007: from MTL_SYSTEM_ITEMS_B msi, MTL_SYSTEM_ITEMS_INTERFACE msii
6008: where item_rec.inventory_item_id = msii.inventory_item_id
6009: and item_rec.inventory_item_id = msi.inventory_item_id
6010: and msii.transaction_type in ('UPDATE','AUTO_CHILD')
6011: and msi.organization_id = msii.organization_id

Line 6022: l_org_id mtl_system_items_interface.organization_id%TYPE;

6018: obj_version_error EXCEPTION;
6019: PRAGMA EXCEPTION_INIT (resource_busy, -54);
6020:
6021: -- 2810346: Lock failed record details into log
6022: l_org_id mtl_system_items_interface.organization_id%TYPE;
6023: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;
6024:
6025: l_target_lc_id mtl_system_items_b.lifecycle_id%TYPE;
6026:

Line 6023: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;

6019: PRAGMA EXCEPTION_INIT (resource_busy, -54);
6020:
6021: -- 2810346: Lock failed record details into log
6022: l_org_id mtl_system_items_interface.organization_id%TYPE;
6023: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;
6024:
6025: l_target_lc_id mtl_system_items_b.lifecycle_id%TYPE;
6026:
6027: BEGIN

Line 6025: l_target_lc_id mtl_system_items_b.lifecycle_id%TYPE;

6021: -- 2810346: Lock failed record details into log
6022: l_org_id mtl_system_items_interface.organization_id%TYPE;
6023: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;
6024:
6025: l_target_lc_id mtl_system_items_b.lifecycle_id%TYPE;
6026:
6027: BEGIN
6028: SAVEPOINT before_lock; -- Bug 5997870
6029: FOR rec IN C_lock_msi_records LOOP

Line 6162: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_FLAG'

6158: IF ( rec.transaction_type = 'UPDATE') THEN
6159: -- Bug 12669090 : Start : Similar to the code change done in the bug 9833451 (12.1)
6160: select count(1) into l_co_control_level
6161: from mtl_item_attributes
6162: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_FLAG'
6163: and control_level = 1
6164: and rec.CUSTOMER_ORDER_FLAG = 'Y';
6165:
6166: select count(1) into l_io_control_level

Line 6168: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_FLAG'

6164: and rec.CUSTOMER_ORDER_FLAG = 'Y';
6165:
6166: select count(1) into l_io_control_level
6167: from mtl_item_attributes
6168: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_FLAG'
6169: and control_level = 1
6170: and rec.INTERNAL_ORDER_FLAG = 'Y';
6171:
6172: IF (l_co_control_level = 1 OR l_io_control_level = 1) THEN

Line 6223: FROM mtl_system_items_b i

6219: decode( rec.CUSTOMER_ORDER_FLAG, 'Y', 11, 0 )
6220: )
6221: and EXISTS
6222: ( SELECT 'x'
6223: FROM mtl_system_items_b i
6224: WHERE i.inventory_item_id = rec.inventory_item_id
6225: AND i.organization_id = mp.organization_id
6226: )
6227: -- Check if the item already has any category assignment

Line 6240: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_FLAG'

6236: )
6237: and (exists
6238: (select 'co_mst_controlled'
6239: from mtl_item_attributes
6240: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.CUSTOMER_ORDER_FLAG'
6241: and control_level = 1
6242: and rec.CUSTOMER_ORDER_FLAG = 'Y')
6243: or exists
6244: (select 'io_mst_controlled'

Line 6246: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_FLAG'

6242: and rec.CUSTOMER_ORDER_FLAG = 'Y')
6243: or exists
6244: (select 'io_mst_controlled'
6245: from mtl_item_attributes
6246: WHERE attribute_name = 'MTL_SYSTEM_ITEMS.INTERNAL_ORDER_FLAG'
6247: and control_level = 1
6248: and rec.INTERNAL_ORDER_FLAG = 'Y')
6249: );
6250: END IF;

Line 6294: FROM mtl_system_items_b i

6290: decode( rec.CUSTOMER_ORDER_FLAG, 'Y', 11, 0 )
6291: )
6292: and EXISTS
6293: ( SELECT 'x'
6294: FROM mtl_system_items_b i
6295: WHERE i.inventory_item_id = rec.inventory_item_id
6296: AND i.organization_id = rec.organization_id
6297: )
6298: -- Check if the item already has any category assignment

Line 6429: UPDATE MTL_SYSTEM_ITEMS_B MTLSYSI

6425: END IF;
6426:
6427: -- bug 10373720 , set last_update_date = sysdate
6428: -- old Modified l_sysdate => Nvl(rec.LAST_UPDATE_DATE,l_sysdate) for Bug - 3313863
6429: UPDATE MTL_SYSTEM_ITEMS_B MTLSYSI
6430: SET
6431: LAST_UPDATE_DATE = l_sysdate,
6432: LAST_UPDATED_BY = user_id,
6433: LAST_UPDATE_LOGIN = login_id,

Line 6836: update MTL_SYSTEM_ITEMS_TL

6832: --
6833: -- bug 10373720 , set last_update_date = sysdate,
6834: -- old Nvl(rec.LAST_UPDATE_DATE,l_sysdate),
6835: ---
6836: update MTL_SYSTEM_ITEMS_TL
6837: set
6838: DESCRIPTION = rec.DESCRIPTION,
6839: LONG_DESCRIPTION = rec.LONG_DESCRIPTION,
6840: LAST_UPDATE_DATE = l_sysdate,

Line 6882: update mtl_system_items_interface

6878:
6879: EXCEPTION
6880:
6881: when obj_version_error THEN -- bug 5870114
6882: update mtl_system_items_interface
6883: set process_flag = 3,
6884: request_id = req_id,
6885: PROGRAM_APPLICATION_ID = prg_appid,
6886: PROGRAM_ID = prg_id,

Line 6896: FROM mtl_system_items_interface

6892: -- Returning clause is commented and change to select clause a part of bug 5870114 as it was throwing TOO_MANY_RECORDS errors
6893:
6894: SELECT organization_id, transaction_id INTO
6895: l_org_id,l_transaction_id
6896: FROM mtl_system_items_interface
6897: WHERE inventory_item_id = item_rec.inventory_item_id
6898: and (set_process_id = xset_id or set_process_id = xset_id + 1000000000000)
6899: and process_flag = 3 AND ROWNUM=1;
6900:

Line 6911: 'MTL_SYSTEM_ITEMS',

6907: req_id,
6908: l_transaction_id,
6909: err_text,
6910: 'INVENTORY_ITEM_ID',
6911: 'MTL_SYSTEM_ITEMS',
6912: 'INV_IOI_RECORD_LOCKED',
6913: err_text);
6914: when resource_busy then
6915:

Line 6920: update mtl_system_items_interface

6916: -- 2810346: Lock failed record details into log
6917: -- Updating the interface records and then logging errors
6918: -- Earlier it was log and then update. Doing this to avoid a fetch.
6919:
6920: update mtl_system_items_interface
6921: set process_flag = 3,
6922: request_id = req_id,
6923: PROGRAM_APPLICATION_ID = prg_appid,
6924: PROGRAM_ID = prg_id,

Line 6933: FROM mtl_system_items_interface

6929: and process_flag = 4;
6930: --RETURNING organization_id,transaction_id INTO l_org_id,l_transaction_id;
6931:
6932: SELECT organization_id, transaction_id INTO l_org_id,l_transaction_id
6933: FROM mtl_system_items_interface
6934: WHERE inventory_item_id = item_rec.inventory_item_id
6935: and (set_process_id = xset_id or set_process_id = xset_id +1000000000000)
6936: and process_flag = 3 AND ROWNUM=1;
6937:

Line 6948: 'MTL_SYSTEM_ITEMS',

6944: req_id,
6945: l_transaction_id,
6946: err_text,
6947: 'INVENTORY_ITEM_ID',
6948: 'MTL_SYSTEM_ITEMS',
6949: 'INV_IOI_RECORD_LOCKED',
6950: err_text);
6951: /* commit for debugging ONLY */
6952: -- COMMIT;

Line 6980: UPDATE mtl_system_items_b

6976: INVPUTLI.info('INVUPD2B: Update: III' || item_csr.inventory_item_id ||
6977: 'segment1' || item_csr.segment1);
6978: END IF;
6979:
6980: UPDATE mtl_system_items_b
6981: SET segment1 = item_csr.segment1,
6982: segment2 = item_csr.segment2,
6983: segment3 = item_csr.segment3,
6984: segment4 = item_csr.segment4,

Line 7009: UPDATE MTL_SYSTEM_ITEMS_TL

7005: -- Start fix for bug 7017691 Issue #4 Move out of the C_msii_processed_records
7006: -- loop
7007: FOR cr IN c_ego_intf_rows LOOP
7008: INVPUTLI.info('Ego Intf Table has rows '||cr.language || ' ' ||cr.column_value);
7009: UPDATE MTL_SYSTEM_ITEMS_TL
7010: SET DESCRIPTION = NVL(cr.column_value, DESCRIPTION),
7011: LAST_UPDATE_DATE = l_sysdate,
7012: LAST_UPDATED_BY = user_id,
7013: LAST_UPDATE_LOGIN = login_id

Line 7076: l_org_id mtl_system_items_interface.organization_id%TYPE ;

7072: FOR UPDATE of revision_id;
7073:
7074: resource_busy EXCEPTION;
7075: PRAGMA EXCEPTION_INIT (resource_busy, -54);
7076: l_org_id mtl_system_items_interface.organization_id%TYPE ;
7077: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;
7078:
7079: BEGIN
7080:

Line 7077: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;

7073:
7074: resource_busy EXCEPTION;
7075: PRAGMA EXCEPTION_INIT (resource_busy, -54);
7076: l_org_id mtl_system_items_interface.organization_id%TYPE ;
7077: l_transaction_id mtl_system_items_interface.transaction_id%TYPE;
7078:
7079: BEGIN
7080:
7081:

Line 7194: 'MTL_SYSTEM_ITEMS',

7190: req_id,
7191: l_transaction_id,
7192: err_text,
7193: 'INVENTORY_ITEM_ID',
7194: 'MTL_SYSTEM_ITEMS',
7195: 'INV_IOI_RECORD_LOCKED',
7196: err_text);
7197: WHEN OTHERS THEN
7198: --bug #4251913: Included SQLCODE and SQLERRM to trap exception messages.

Line 7217: table_name := 'MTL_SYSTEM_ITEMS_INTERFACE';

7213: --INVPUTLI.info('INVPPROC: Finished updating record in MSI with MSII record'|| xset_id);
7214:
7215: -- set process_flags to 7
7216:
7217: table_name := 'MTL_SYSTEM_ITEMS_INTERFACE';
7218: update MTL_SYSTEM_ITEMS_INTERFACE
7219: set process_flag = 7,
7220: request_id = req_id,
7221: PROGRAM_APPLICATION_ID = prg_appid,

Line 7218: update MTL_SYSTEM_ITEMS_INTERFACE

7214:
7215: -- set process_flags to 7
7216:
7217: table_name := 'MTL_SYSTEM_ITEMS_INTERFACE';
7218: update MTL_SYSTEM_ITEMS_INTERFACE
7219: set process_flag = 7,
7220: request_id = req_id,
7221: PROGRAM_APPLICATION_ID = prg_appid,
7222: PROGRAM_ID = prg_id,

Line 7283: update MTL_SYSTEM_ITEMS_INTERFACE

7279:
7280: IF l_inv_debug_level IN(101, 102) THEN
7281: INVPUTLI.info('INVUPD2B: Inside set_process_flag3');
7282: END IF;
7283: update MTL_SYSTEM_ITEMS_INTERFACE
7284: set PROCESS_FLAG = l_process_flag_3,
7285: request_id = reqst_id,
7286: PROGRAM_APPLICATION_ID = prog_appid,
7287: PROGRAM_ID = prog_id,

Line 7395: l_level := get_control_level('MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG');

7391: */
7392: INACTIVE_CODE := 1000; -- 1000 means status code is Obsolete/Archived.
7393:
7394: /* Check at which level the attribute is controlled. */
7395: l_level := get_control_level('MTL_SYSTEM_ITEMS.RECIPE_ENABLED_FLAG');
7396: IF (l_level = 1) THEN
7397: OPEN C_MASTER;
7398: FETCH C_MASTER INTO DUMMY;
7399: IF(C_MASTER%FOUND) THEN