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 BOM_SUB_COMPS_INTERFACE

Line 959: bom_sub_comps_interface bsc

955:
956: select count(*) /* Comp and sub comp in interface */
957: into cnt
958: from bom_inventory_comps_interface bic,
959: bom_sub_comps_interface bsc
960: where bic.bill_sequence_id = cmn_bom_id
961: and bic.process_flag in (2, 4)
962: and bsc.process_flag in (2, 4)
963: and bic.component_sequence_id = bsc.component_sequence_id

Line 978: bom_sub_comps_interface bsc

974:
975: select count(*) /* Comp in production and sub comp in interface */
976: into cnt
977: from bom_inventory_components bic,
978: bom_sub_comps_interface bsc
979: where bic.bill_sequence_id = cmn_bom_id
980: and bsc.process_flag in (2, 4)
981: and bic.component_sequence_id = bsc.component_sequence_id
982: and bsc.substitute_component_id not in

Line 3006: from bom_sub_comps_interface

3002: cursor c1 is
3003: select component_sequence_id CSI, count(*) CNT,
3004: transaction_id TI, assembly_item_id AII,
3005: organization_id OI
3006: from bom_sub_comps_interface
3007: where process_flag = 2
3008: and rownum < 500
3009: group by transaction_id, component_sequence_id,
3010: organization_id, assembly_item_id;

Line 3015: from bom_sub_comps_interface

3011:
3012: BEGIN
3013: select count(distinct component_sequence_id)
3014: into total_recs
3015: from bom_sub_comps_interface
3016: where process_flag = 2;
3017:
3018: commit_cnt := 0;
3019:

Line 3040: tbl_name => 'BOM_SUB_COMPS_INTERFACE',

3036: prog_id => prog_id,
3037: req_id => request_id,
3038: trans_id => c1rec.TI,
3039: error_text => err_text,
3040: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3041: msg_name => 'BOM_COMP_SEQ_ID_INVALID',
3042: err_text => err_text);
3043: update bom_sub_comps_interface set
3044: process_flag = 3

Line 3043: update bom_sub_comps_interface set

3039: error_text => err_text,
3040: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3041: msg_name => 'BOM_COMP_SEQ_ID_INVALID',
3042: err_text => err_text);
3043: update bom_sub_comps_interface set
3044: process_flag = 3
3045: where transaction_id = c1rec.TI;
3046:
3047: if (ret_code <> 0) then

Line 3127: tbl_name => 'BOM_SUB_COMPS_INTERFACE',

3123: prog_id => prog_id,
3124: req_id => request_id,
3125: trans_id => c1rec.TI,
3126: error_text => err_text,
3127: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3128: msg_name => 'BOM_NO_SUB_COMPS_ALLOWED',
3129: err_text => err_text);
3130: update bom_sub_comps_interface set
3131: process_flag = 3

Line 3130: update bom_sub_comps_interface set

3126: error_text => err_text,
3127: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3128: msg_name => 'BOM_NO_SUB_COMPS_ALLOWED',
3129: err_text => err_text);
3130: update bom_sub_comps_interface set
3131: process_flag = 3
3132: where transaction_id = c1rec.TI;
3133:
3134: if (ret_code <> 0) then

Line 3150: tbl_name => 'BOM_SUB_COMPS_INTERFACE',

3146: prog_id => prog_id,
3147: req_id => request_id,
3148: trans_id => c1rec.TI,
3149: error_text => err_text,
3150: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3151: msg_name => 'BOM_NO_SUB_COMPS_COMP',
3152: err_text => err_text);
3153: update bom_sub_comps_interface set
3154: process_flag = 3

Line 3153: update bom_sub_comps_interface set

3149: error_text => err_text,
3150: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3151: msg_name => 'BOM_NO_SUB_COMPS_COMP',
3152: err_text => err_text);
3153: update bom_sub_comps_interface set
3154: process_flag = 3
3155: where transaction_id = c1rec.TI;
3156:
3157: if (ret_code <> 0) then

Line 3168: from bom_sub_comps_interface a

3164: ** Check substitute item existence in item master
3165: */
3166: select count(*)
3167: into dummy
3168: from bom_sub_comps_interface a
3169: where transaction_id = c1rec.TI
3170: and process_flag <> 3 and process_flag <> 7
3171: and not exists (select 'items exist'
3172: from mtl_system_items b

Line 3187: tbl_name => 'BOM_SUB_COMPS_INTERFACE',

3183: prog_id => prog_id,
3184: req_id => request_id,
3185: trans_id => c1rec.TI,
3186: error_text => err_text,
3187: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3188: msg_name => 'BOM_SUB_COMP_ITEM_INVALID',
3189: err_text => err_text);
3190: update bom_sub_comps_interface set
3191: process_flag = 3

Line 3190: update bom_sub_comps_interface set

3186: error_text => err_text,
3187: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3188: msg_name => 'BOM_SUB_COMP_ITEM_INVALID',
3189: err_text => err_text);
3190: update bom_sub_comps_interface set
3191: process_flag = 3
3192: where transaction_id = c1rec.TI;
3193:
3194: if (ret_code <> 0) then

Line 3216: tbl_name => 'BOM_SUB_COMPS_INTERFACE',

3212: prog_id => prog_id,
3213: req_id => request_id,
3214: trans_id => c1rec.TI,
3215: error_text => err_text,
3216: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3217: msg_name => 'BOM_DUPLICATE_SUB_COMP',
3218: err_text => err_text);
3219: update bom_sub_comps_interface set
3220: process_flag = 3

Line 3219: update bom_sub_comps_interface set

3215: error_text => err_text,
3216: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3217: msg_name => 'BOM_DUPLICATE_SUB_COMP',
3218: err_text => err_text);
3219: update bom_sub_comps_interface set
3220: process_flag = 3
3221: where transaction_id = c1rec.TI;
3222:
3223: if (ret_code <> 0) then

Line 3234: from bom_sub_comps_interface

3230: ** Verify sub comp is not the same as bill or component
3231: */
3232: select count(*)
3233: into dummy
3234: from bom_sub_comps_interface
3235: where transaction_id = c1rec.TI
3236: and (SUBSTITUTE_COMPONENT_ID = assy_id_dummy
3237: or
3238: SUBSTITUTE_COMPONENT_ID = comp_id_dummy)

Line 3252: tbl_name => 'BOM_SUB_COMPS_INTERFACE',

3248: prog_id => prog_id,
3249: req_id => request_id,
3250: trans_id => c1rec.TI,
3251: error_text => err_text,
3252: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3253: msg_name => 'BOM_SUB_COMP_ITEM_SAME',
3254: err_text => err_text);
3255: update bom_sub_comps_interface set
3256: process_flag = 3

Line 3255: update bom_sub_comps_interface set

3251: error_text => err_text,
3252: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3253: msg_name => 'BOM_SUB_COMP_ITEM_SAME',
3254: err_text => err_text);
3255: update bom_sub_comps_interface set
3256: process_flag = 3
3257: where transaction_id = c1rec.TI;
3258:
3259: if (ret_code <> 0) then

Line 3270: from bom_sub_comps_interface bsc

3266: ** Check substitute item attributes
3267: */
3268: select count(*)
3269: into dummy
3270: from bom_sub_comps_interface bsc
3271: where bsc.transaction_id = c1rec.TI
3272: and not exists (select 'x'
3273: from mtl_system_items msi
3274: where organization_id = org_id_dummy

Line 3293: tbl_name => 'BOM_SUB_COMPS_INTERFACE',

3289: prog_id => prog_id,
3290: req_id => request_id,
3291: trans_id => c1rec.TI,
3292: error_text => err_text,
3293: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3294: msg_name => 'BOM_SUB_COMP_ITEM_ATTR_INVALID',
3295: err_text => err_text);
3296: update bom_sub_comps_interface set
3297: process_flag = 3

Line 3296: update bom_sub_comps_interface set

3292: error_text => err_text,
3293: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3294: msg_name => 'BOM_SUB_COMP_ITEM_ATTR_INVALID',
3295: err_text => err_text);
3296: update bom_sub_comps_interface set
3297: process_flag = 3
3298: where transaction_id = c1rec.TI;
3299:
3300: if (ret_code <> 0) then

Line 3311: from bom_sub_comps_interface

3307: ** Substitute item quantity cannot be zero
3308: */
3309: select count(*)
3310: into dummy
3311: from bom_sub_comps_interface
3312: where transaction_id = c1rec.TI
3313: and process_flag <> 3 and process_flag <> 7
3314: and substitute_item_quantity = 0;
3315: if (dummy <> 0) then

Line 3326: tbl_name => 'BOM_SUB_COMPS_INTERFACE',

3322: prog_id => prog_id,
3323: req_id => request_id,
3324: trans_id => c1rec.TI,
3325: error_text => err_text,
3326: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3327: msg_name => 'BOM_SUB_COMP_QTY_ZERO',
3328: err_text => err_text);
3329: update bom_sub_comps_interface set
3330: process_flag = 3

Line 3329: update bom_sub_comps_interface set

3325: error_text => err_text,
3326: tbl_name => 'BOM_SUB_COMPS_INTERFACE',
3327: msg_name => 'BOM_SUB_COMP_QTY_ZERO',
3328: err_text => err_text);
3329: update bom_sub_comps_interface set
3330: process_flag = 3
3331: where transaction_id = c1rec.TI;
3332:
3333: if (ret_code <> 0) then

Line 3339: update bom_sub_comps_interface

3335: end if;
3336: goto continue_loop;
3337: end if;
3338:
3339: update bom_sub_comps_interface
3340: set process_flag = 4
3341: where transaction_id = c1rec.TI;
3342:
3343: <>

Line 3396: from bom_substitute_components a, bom_sub_comps_interface b

3392: */
3393: begin
3394: select 1
3395: into dummy
3396: from bom_substitute_components a, bom_sub_comps_interface b
3397: where b.transaction_id = trans_id
3398: and a.component_sequence_id = b.component_sequence_id
3399: and a.SUBSTITUTE_COMPONENT_ID =
3400: b.SUBSTITUTE_COMPONENT_ID

Line 3418: from bom_sub_comps_interface a

3414: ** check in interface table
3415: */
3416: select count(*)
3417: into dummy
3418: from bom_sub_comps_interface a
3419: where transaction_id = trans_id
3420: and exists (select 'same substitue'
3421: from bom_sub_comps_interface b
3422: where b.transaction_id = trans_id

Line 3421: from bom_sub_comps_interface b

3417: into dummy
3418: from bom_sub_comps_interface a
3419: where transaction_id = trans_id
3420: and exists (select 'same substitue'
3421: from bom_sub_comps_interface b
3422: where b.transaction_id = trans_id
3423: and b.rowid <> a.rowid
3424: and b.SUBSTITUTE_COMPONENT_ID =
3425: a.SUBSTITUTE_COMPONENT_ID