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.BOMPVALB dependencies on MTL_ITEM_REVISIONS

Line 3483: from mtl_item_revisions_interface

3479: IS
3480: cursor c0 is
3481: select inventory_item_id AII, organization_id OI,
3482: revision R, transaction_id TI
3483: from mtl_item_revisions_interface
3484: where process_flag = 2
3485: and rownum < 500;
3486:
3487: cursor c1 is

Line 3489: from mtl_item_revisions_interface

3485: and rownum < 500;
3486:
3487: cursor c1 is
3488: select inventory_item_id AII, organization_id OI
3489: from mtl_item_revisions_interface
3490: where process_flag = 99
3491: and rownum < 500
3492: group by organization_id, inventory_item_id;
3493:

Line 3496: from mtl_item_revisions_interface

3492: group by organization_id, inventory_item_id;
3493:
3494: cursor c2 is
3495: select 'x'
3496: from mtl_item_revisions_interface
3497: where process_flag = 99
3498: group by organization_id, inventory_item_id;
3499:
3500: ret_code NUMBER;

Line 3528: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',

3524: prog_id => prog_id,
3525: req_id => req_id,
3526: trans_id => c0rec.TI,
3527: error_text => err_text,
3528: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',
3529: msg_name => 'BOM_NULL_REV',
3530: err_text => err_text);
3531: update mtl_item_revisions_interface set
3532: process_flag = 3

Line 3531: update mtl_item_revisions_interface set

3527: error_text => err_text,
3528: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',
3529: msg_name => 'BOM_NULL_REV',
3530: err_text => err_text);
3531: update mtl_item_revisions_interface set
3532: process_flag = 3
3533: where transaction_id = c0rec.TI;
3534:
3535: if (ret_code <> 0) then

Line 3560: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',

3556: prog_id => prog_id,
3557: req_id => req_id,
3558: trans_id => c0rec.TI,
3559: error_text => err_text,
3560: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',
3561: msg_name => 'BOM_INVALID_ORG_ID',
3562: err_text => err_text);
3563: update mtl_item_revisions_interface set
3564: process_flag = 3

Line 3563: update mtl_item_revisions_interface set

3559: error_text => err_text,
3560: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',
3561: msg_name => 'BOM_INVALID_ORG_ID',
3562: err_text => err_text);
3563: update mtl_item_revisions_interface set
3564: process_flag = 3
3565: where transaction_id = c0rec.TI;
3566: if (ret_code <> 0) then
3567: return(ret_code);

Line 3588: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',

3584: prog_id => prog_id,
3585: req_id => req_id,
3586: trans_id => c0rec.TI,
3587: error_text => err_text,
3588: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',
3589: msg_name => 'BOM_INV_ITEM_INVALID',
3590: err_text => err_text);
3591: update mtl_item_revisions_interface set
3592: process_flag = 3

Line 3591: update mtl_item_revisions_interface set

3587: error_text => err_text,
3588: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',
3589: msg_name => 'BOM_INV_ITEM_INVALID',
3590: err_text => err_text);
3591: update mtl_item_revisions_interface set
3592: process_flag = 3
3593: where transaction_id = c0rec.TI;
3594:
3595: if (ret_code <> 0) then

Line 3630: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',

3626: prog_id => prog_id,
3627: req_id => req_id,
3628: trans_id => c0rec.TI,
3629: error_text => err_text,
3630: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',
3631: msg_name => 'BOM_BILL_DOES_NOT_EXIST',
3632: err_text => err_text);
3633: update mtl_item_revisions_interface set
3634: process_flag = 3

Line 3633: update mtl_item_revisions_interface set

3629: error_text => err_text,
3630: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',
3631: msg_name => 'BOM_BILL_DOES_NOT_EXIST',
3632: err_text => err_text);
3633: update mtl_item_revisions_interface set
3634: process_flag = 3
3635: where transaction_id = c0rec.TI;
3636:
3637: if (ret_code <> 0) then

Line 3644: update mtl_item_revisions_interface set

3640: goto continue_loop;
3641: end if;
3642: end if;
3643:
3644: update mtl_item_revisions_interface set
3645: process_flag = 99
3646: where transaction_id = c0rec.TI;
3647:
3648: <>

Line 3738: from mtl_item_revisions_interface

3734: IS
3735: cursor c1 is
3736: select revision R, effectivity_date ED,
3737: transaction_id TI
3738: from mtl_item_revisions_interface
3739: where organization_id = org_id
3740: and inventory_item_id = assy_id
3741: and process_flag = 99;
3742: ret_code NUMBER;

Line 3755: from mtl_item_revisions_interface a

3751: ** check for ascending order and identical revs
3752: */
3753: select count(*)
3754: into err_cnt
3755: from mtl_item_revisions_interface a
3756: where transaction_id <> c1rec.TI
3757: and inventory_item_id = assy_id
3758: and organization_id = org_id
3759: and process_flag = 4

Line 3776: from mtl_item_revisions

3772:
3773: stmt_num := 2;
3774: select count(*)
3775: into err_cnt
3776: from mtl_item_revisions
3777: where inventory_item_id = assy_id
3778: and organization_id = org_id
3779: and ( (revision = c1rec.R)
3780: or

Line 3793: update mtl_item_revisions_interface set

3789: goto write_error;
3790: end if;
3791:
3792: stmt_num := 3;
3793: update mtl_item_revisions_interface set
3794: process_flag = 4
3795: where transaction_id = c1rec.TI;
3796: goto continue_loop;
3797:

Line 3808: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',

3804: prog_id => prog_id,
3805: req_id => req_id,
3806: trans_id => c1rec.TI,
3807: error_text => err_text,
3808: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',
3809: msg_name => 'BOM_REV_INVALID',
3810: err_text => err_text);
3811: update mtl_item_revisions_interface set
3812: process_flag = 3

Line 3811: update mtl_item_revisions_interface set

3807: error_text => err_text,
3808: tbl_name => 'MTL_ITEM_REVISIONS_INTERFACE',
3809: msg_name => 'BOM_REV_INVALID',
3810: err_text => err_text);
3811: update mtl_item_revisions_interface set
3812: process_flag = 3
3813: where transaction_id = c1rec.TI;
3814: <>
3815: null;