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.EGO_ITEM_PUB dependencies on MTL_PENDING_ITEM_STATUS

Line 3358: UPDATE MTL_PENDING_ITEM_STATUS SET LIFECYCLE_ID = P_LIFECYCLE_ID

3354: UPDATE MTL_SYSTEM_ITEMS_B SET INVENTORY_ITEM_STATUS_CODE = P_ITEM_STATUS
3355: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3356: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3357:
3358: UPDATE MTL_PENDING_ITEM_STATUS SET LIFECYCLE_ID = P_LIFECYCLE_ID
3359: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3360: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3361:
3362: UPDATE MTL_PENDING_ITEM_STATUS SET PHASE_ID = P_CURRENT_PHASE_ID

Line 3362: UPDATE MTL_PENDING_ITEM_STATUS SET PHASE_ID = P_CURRENT_PHASE_ID

3358: UPDATE MTL_PENDING_ITEM_STATUS SET LIFECYCLE_ID = P_LIFECYCLE_ID
3359: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3360: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3361:
3362: UPDATE MTL_PENDING_ITEM_STATUS SET PHASE_ID = P_CURRENT_PHASE_ID
3363: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3364: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3365:
3366: UPDATE MTL_PENDING_ITEM_STATUS SET STATUS_CODE = P_ITEM_STATUS

Line 3366: UPDATE MTL_PENDING_ITEM_STATUS SET STATUS_CODE = P_ITEM_STATUS

3362: UPDATE MTL_PENDING_ITEM_STATUS SET PHASE_ID = P_CURRENT_PHASE_ID
3363: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3364: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3365:
3366: UPDATE MTL_PENDING_ITEM_STATUS SET STATUS_CODE = P_ITEM_STATUS
3367: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3368: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3369:
3370: IF FND_API.To_Boolean(p_commit) THEN

Line 3438: -- Insert a row to Mtl_Pending_Item_Status table with master organization id

3434: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID;
3435: ELSE
3436: L_CONTROL_LEVEL := EGO_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');
3437:
3438: -- Insert a row to Mtl_Pending_Item_Status table with master organization id
3439: -- and pending_flag = N.
3440: INSERT INTO MTL_PENDING_ITEM_STATUS(
3441: INVENTORY_ITEM_ID,
3442: ORGANIZATION_ID,

Line 3440: INSERT INTO MTL_PENDING_ITEM_STATUS(

3436: L_CONTROL_LEVEL := EGO_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');
3437:
3438: -- Insert a row to Mtl_Pending_Item_Status table with master organization id
3439: -- and pending_flag = N.
3440: INSERT INTO MTL_PENDING_ITEM_STATUS(
3441: INVENTORY_ITEM_ID,
3442: ORGANIZATION_ID,
3443: EFFECTIVE_DATE,
3444: IMPLEMENTED_DATE,

Line 3484: INSERT INTO MTL_PENDING_ITEM_STATUS(

3480: LOOP
3481: FETCH ego_item_assigned_org_csr INTO L_ITEM_ASSIGNED_ORG_REC;
3482: EXIT WHEN ego_item_assigned_org_csr%NOTFOUND;
3483:
3484: INSERT INTO MTL_PENDING_ITEM_STATUS(
3485: INVENTORY_ITEM_ID,
3486: ORGANIZATION_ID,
3487: EFFECTIVE_DATE,
3488: PENDING_FLAG,

Line 3526: INSERT INTO MTL_PENDING_ITEM_STATUS(

3522: LOOP
3523: FETCH ego_item_assigned_org_csr INTO L_ITEM_ASSIGNED_ORG_REC;
3524: EXIT WHEN ego_item_assigned_org_csr%NOTFOUND;
3525:
3526: INSERT INTO MTL_PENDING_ITEM_STATUS(
3527: INVENTORY_ITEM_ID,
3528: ORGANIZATION_ID,
3529: EFFECTIVE_DATE,
3530: IMPLEMENTED_DATE,