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 3551: UPDATE MTL_PENDING_ITEM_STATUS SET LIFECYCLE_ID = P_LIFECYCLE_ID

3547: UPDATE MTL_SYSTEM_ITEMS_B SET INVENTORY_ITEM_STATUS_CODE = P_ITEM_STATUS
3548: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3549: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3550:
3551: UPDATE MTL_PENDING_ITEM_STATUS SET LIFECYCLE_ID = P_LIFECYCLE_ID
3552: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3553: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3554:
3555: UPDATE MTL_PENDING_ITEM_STATUS SET PHASE_ID = P_CURRENT_PHASE_ID

Line 3555: UPDATE MTL_PENDING_ITEM_STATUS SET PHASE_ID = P_CURRENT_PHASE_ID

3551: UPDATE MTL_PENDING_ITEM_STATUS SET LIFECYCLE_ID = P_LIFECYCLE_ID
3552: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3553: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3554:
3555: UPDATE MTL_PENDING_ITEM_STATUS SET PHASE_ID = P_CURRENT_PHASE_ID
3556: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3557: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3558:
3559: UPDATE MTL_PENDING_ITEM_STATUS SET STATUS_CODE = P_ITEM_STATUS

Line 3559: UPDATE MTL_PENDING_ITEM_STATUS SET STATUS_CODE = P_ITEM_STATUS

3555: UPDATE MTL_PENDING_ITEM_STATUS SET PHASE_ID = P_CURRENT_PHASE_ID
3556: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3557: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3558:
3559: UPDATE MTL_PENDING_ITEM_STATUS SET STATUS_CODE = P_ITEM_STATUS
3560: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3561: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3562:
3563: IF FND_API.To_Boolean(p_commit) THEN

Line 3636: SELECT MAX(MPIS.status_code) INTO L_CURRENT_STATUS_CODE FROM MTL_PENDING_ITEM_STATUS MPIS WHERE MPIS.INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID AND MPIS.ORGANIZATION_ID = P_ORGANIZATION_ID AND

3632: X_RETURN_STATUS := FND_API.g_RET_STS_SUCCESS;
3633: X_MSG_COUNT := 0;
3634:
3635: --Bug 13489639
3636: SELECT MAX(MPIS.status_code) INTO L_CURRENT_STATUS_CODE FROM MTL_PENDING_ITEM_STATUS MPIS WHERE MPIS.INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID AND MPIS.ORGANIZATION_ID = P_ORGANIZATION_ID AND
3637: MPIS.pending_flag = 'N' AND effective_date = (SELECT MAX(effective_date) FROM MTL_PENDING_ITEM_STATUS STA WHERE STA.INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID AND STA.ORGANIZATION_ID = P_ORGANIZATION_ID AND STA.pending_flag = 'N');
3638:
3639: IF L_CURRENT_STATUS_CODE IS NULL THEN
3640: L_UPDATE_STATUS_HIS_IND := FALSE;

Line 3637: MPIS.pending_flag = 'N' AND effective_date = (SELECT MAX(effective_date) FROM MTL_PENDING_ITEM_STATUS STA WHERE STA.INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID AND STA.ORGANIZATION_ID = P_ORGANIZATION_ID AND STA.pending_flag = 'N');

3633: X_MSG_COUNT := 0;
3634:
3635: --Bug 13489639
3636: SELECT MAX(MPIS.status_code) INTO L_CURRENT_STATUS_CODE FROM MTL_PENDING_ITEM_STATUS MPIS WHERE MPIS.INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID AND MPIS.ORGANIZATION_ID = P_ORGANIZATION_ID AND
3637: MPIS.pending_flag = 'N' AND effective_date = (SELECT MAX(effective_date) FROM MTL_PENDING_ITEM_STATUS STA WHERE STA.INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID AND STA.ORGANIZATION_ID = P_ORGANIZATION_ID AND STA.pending_flag = 'N');
3638:
3639: IF L_CURRENT_STATUS_CODE IS NULL THEN
3640: L_UPDATE_STATUS_HIS_IND := FALSE;
3641: ELSIF (P_ITEM_STATUS = L_CURRENT_STATUS_CODE) THEN

Line 3649: /*Changes for bug 7659489. Even when ICC is not associated to an item changes to Item status should be inserted into MTL_PENDING_ITEM_STATUSES

3645: L_MASTER_ORGANIZATION_ID := EGO_ITEM_PUB.Get_Master_Organization_Id(P_ORGANIZATION_ID => P_ORGANIZATION_ID);
3646: /*Changed for bug 7660662*/
3647:
3648: --IF (P_ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID) THEN
3649: /*Changes for bug 7659489. Even when ICC is not associated to an item changes to Item status should be inserted into MTL_PENDING_ITEM_STATUSES
3650: so that the history of changes is properly logged*/
3651: L_CONTROL_LEVEL := EGO_ITEM_PUB.Get_Item_Attr_Control_Level(P_ITEM_ATTRIBUTE => 'MTL_SYSTEM_ITEMS.INVENTORY_ITEM_STATUS_CODE');
3652: IF (P_CATALOG_GROUP_ID IS NULL) THEN
3653: FOR rec IN ego_item_all_assigned_org_csr(v_inventory_item_id=> P_INVENTORY_ITEM_ID,v_master_organization_id => L_MASTER_ORGANIZATION_ID) LOOP

Line 3665: INSERT INTO MTL_PENDING_ITEM_STATUS(

3661: AND ORGANIZATION_ID = rec.organization_id;
3662:
3663: /*Added for bug 7659489*/
3664: IF ((L_CONTROL_LEVEL = 1) AND (P_ORGANIZATION_ID = L_MASTER_ORGANIZATION_ID) AND L_UPDATE_STATUS_HIS_IND) THEN
3665: INSERT INTO MTL_PENDING_ITEM_STATUS(
3666: INVENTORY_ITEM_ID,
3667: ORGANIZATION_ID,
3668: EFFECTIVE_DATE,
3669: IMPLEMENTED_DATE,

Line 3696: INSERT INTO MTL_PENDING_ITEM_STATUS(

3692: /*End of bug 7659489*/
3693: END LOOP;
3694: /*Added for bug 7659489*/
3695: IF (L_CONTROL_LEVEL = 2 AND L_UPDATE_STATUS_HIS_IND) THEN
3696: INSERT INTO MTL_PENDING_ITEM_STATUS(
3697: INVENTORY_ITEM_ID,
3698: ORGANIZATION_ID,
3699: EFFECTIVE_DATE,
3700: IMPLEMENTED_DATE,

Line 3741: INSERT INTO MTL_PENDING_ITEM_STATUS(

3737: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3738: AND ORGANIZATION_ID = rec.organization_id;
3739:
3740: if(L_UPDATE_STATUS_HIS_IND) then
3741: INSERT INTO MTL_PENDING_ITEM_STATUS(
3742: INVENTORY_ITEM_ID,
3743: ORGANIZATION_ID,
3744: EFFECTIVE_DATE,
3745: IMPLEMENTED_DATE,

Line 3781: INSERT INTO MTL_PENDING_ITEM_STATUS(

3777: WHERE INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
3778: AND ORGANIZATION_ID = P_ORGANIZATION_ID;
3779:
3780: if(L_UPDATE_STATUS_HIS_IND) then
3781: INSERT INTO MTL_PENDING_ITEM_STATUS(
3782: INVENTORY_ITEM_ID,
3783: ORGANIZATION_ID,
3784: EFFECTIVE_DATE,
3785: IMPLEMENTED_DATE,