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.BOM_COPY_BILL dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 802: FROM mtl_system_items_b_kfv

798: CURSOR l_org_item_csr (p_item_id IN NUMBER, p_org_id IN NUMBER)
799: IS
800: SELECT concatenated_segments,
801: primary_uom_code
802: FROM mtl_system_items_b_kfv
803: WHERE inventory_item_id = p_item_id
804: AND organization_id = p_org_id;
805:
806: CURSOR getcurrentminorrevcode (

Line 3755: mtl_system_items_b_kfv msbk1,

3751:
3752: SELECT COUNT (*)
3753: INTO l_no_access_comp_cnt
3754: FROM bom_components_b bcb,
3755: mtl_system_items_b_kfv msbk1,
3756: bom_copy_explosions_v bev
3757: WHERE bcb.bill_sequence_id = x_from_sequence_id
3758: AND bcb.component_item_id = msbk1.inventory_item_id
3759: AND bcb.component_item_id <> to_item_id

Line 3842: FROM mtl_system_items_b_kfv msbk1

3838: fnd_global.conc_request_id,
3839: NULL,
3840: fnd_global.conc_program_id,
3841: sysdate
3842: FROM mtl_system_items_b_kfv msbk1
3843: WHERE msbk1.inventory_item_id = from_item_id
3844: AND msbk1.organization_id = from_org_id;
3845: END IF;
3846:

Line 3852: mtl_system_items_b_kfv msbk1,

3848: THEN
3849: SELECT COUNT (*)
3850: INTO l_no_access_comp_cnt
3851: FROM bom_components_b bcb,
3852: mtl_system_items_b_kfv msbk1,
3853: bom_copy_explosions_v bev
3854: WHERE bcb.bill_sequence_id = x_from_sequence_id
3855: AND bcb.component_item_id = msbk1.inventory_item_id
3856: AND bcb.component_item_id <> to_item_id

Line 3939: FROM mtl_system_items_b_kfv msbk1

3935: fnd_global.conc_request_id,
3936: NULL,
3937: fnd_global.conc_program_id,
3938: sysdate
3939: FROM mtl_system_items_b_kfv msbk1
3940: WHERE msbk1.inventory_item_id = from_item_id
3941: AND msbk1.organization_id = from_org_id;
3942: END IF;
3943: END IF;

Line 4158: mtl_system_items_b_kfv msbk1,

4154: SYSDATE,
4155: user_id,
4156: 'E'
4157: FROM bom_components_b bcb,
4158: mtl_system_items_b_kfv msbk1,
4159: mtl_system_items_b_kfv msbk2,
4160: bom_copy_explosions_v bev
4161: WHERE bcb.bill_sequence_id = x_from_sequence_id
4162: AND bcb.component_item_id = msbk1.inventory_item_id

Line 4159: mtl_system_items_b_kfv msbk2,

4155: user_id,
4156: 'E'
4157: FROM bom_components_b bcb,
4158: mtl_system_items_b_kfv msbk1,
4159: mtl_system_items_b_kfv msbk2,
4160: bom_copy_explosions_v bev
4161: WHERE bcb.bill_sequence_id = x_from_sequence_id
4162: AND bcb.component_item_id = msbk1.inventory_item_id
4163: AND bcb.component_item_id <> to_item_id

Line 6317: FROM mtl_system_items_b_kfv msbk

6313: FOR component_rec IN c_component_cur (p_sort_order, p_explode_grp_id)
6314: LOOP
6315: SELECT concatenated_segments
6316: INTO l_component_name
6317: FROM mtl_system_items_b_kfv msbk
6318: WHERE msbk.inventory_item_id = component_rec.component_item_id
6319: AND msbk.organization_id = p_org_id;
6320:
6321: IF (l_component_path IS NULL)

Line 6419: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;

6415: l_error_tbl inv_item_grp.error_tbl_type;
6416: x_msg_list error_handler.error_tbl_type;
6417: l_item_org_assign_tbl system.EGO_ITEM_ORG_ASSIGN_TABLE := new system.EGO_ITEM_ORG_ASSIGN_TABLE();
6418: l_trgt_item_uom_code mtl_system_items_b.primary_uom_code%TYPE;
6419: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6420: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;

Line 6420: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;

6416: x_msg_list error_handler.error_tbl_type;
6417: l_item_org_assign_tbl system.EGO_ITEM_ORG_ASSIGN_TABLE := new system.EGO_ITEM_ORG_ASSIGN_TABLE();
6418: l_trgt_item_uom_code mtl_system_items_b.primary_uom_code%TYPE;
6419: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6420: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6424: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;

Line 6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;

6417: l_item_org_assign_tbl system.EGO_ITEM_ORG_ASSIGN_TABLE := new system.EGO_ITEM_ORG_ASSIGN_TABLE();
6418: l_trgt_item_uom_code mtl_system_items_b.primary_uom_code%TYPE;
6419: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6420: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6424: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;
6425: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;

Line 6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;

6418: l_trgt_item_uom_code mtl_system_items_b.primary_uom_code%TYPE;
6419: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6420: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6424: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;
6425: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;
6426: l_not_exists NUMBER := 0;

Line 6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;

6419: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6420: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6424: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;
6425: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;
6426: l_not_exists NUMBER := 0;
6427: l_msg_count NUMBER := 0;

Line 6424: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;

6420: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6424: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;
6425: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;
6426: l_not_exists NUMBER := 0;
6427: l_msg_count NUMBER := 0;
6428: l_item_count NUMBER := 1;

Line 6425: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;

6421: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6422: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6423: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6424: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;
6425: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;
6426: l_not_exists NUMBER := 0;
6427: l_msg_count NUMBER := 0;
6428: l_item_count NUMBER := 1;
6429: l_index NUMBER := 0;

Line 6448: FROM mtl_system_items_b_kfv msibk,

6444: msibk.dual_uom_deviation_low,
6445: msibk.secondary_default_ind,
6446: msibk.tracking_quantity_ind,
6447: msibk.ont_pricing_qty_source
6448: FROM mtl_system_items_b_kfv msibk,
6449: bom_copy_explosions_v bev
6450: WHERE msibk.inventory_item_id = bev.component_item_id
6451: AND msibk.organization_id = bev.organization_id
6452: AND (bev.implementation_date IS NOT NULL

Line 6509: FROM mtl_system_items_b_kfv mmsib

6505: IS
6506: SELECT mmsib.primary_uom_code, 1 l_not_exists, concatenated_segments,
6507: mmsib.secondary_uom_code, mmsib.dual_uom_deviation_high, mmsib.dual_uom_deviation_low,
6508: mmsib.secondary_default_ind, mmsib.tracking_quantity_ind, mmsib.ont_pricing_qty_source
6509: FROM mtl_system_items_b_kfv mmsib
6510: WHERE mmsib.inventory_item_id = p_item_id
6511: AND mmsib.organization_id = p_master_org_id
6512: AND NOT EXISTS
6513: ( SELECT 1

Line 7330: FROM mtl_system_items_b_kfv

7326: CURSOR l_org_item_csr (p_item_id IN NUMBER, p_org_id IN NUMBER)
7327: IS
7328: SELECT concatenated_segments,
7329: primary_uom_code
7330: FROM mtl_system_items_b_kfv
7331: WHERE inventory_item_id = p_item_id
7332: AND organization_id = p_org_id;
7333:
7334: CURSOR l_from_to_comps_csr (

Line 9637: mtl_system_items_b_kfv msbk1,

9633:
9634: SELECT COUNT (*)
9635: INTO l_no_access_comp_cnt
9636: FROM bom_components_b bcb,
9637: mtl_system_items_b_kfv msbk1,
9638: bom_copy_explosions_v bev
9639: WHERE bcb.bill_sequence_id = x_from_sequence_id
9640: AND bcb.component_item_id = msbk1.inventory_item_id
9641: AND bcb.component_item_id <> to_item_id

Line 9738: mtl_system_items_b_kfv msbk1,

9734: NULL,
9735: fnd_global.conc_program_id,
9736: sysdate
9737: FROM bom_components_b bcb,
9738: mtl_system_items_b_kfv msbk1,
9739: bom_copy_explosions_v bev
9740: WHERE msbk1.inventory_item_id = from_item_id
9741: AND msbk1.organization_id = from_org_id
9742: AND bcb.component_sequence_id = bev.component_sequence_id

Line 9766: mtl_system_items_b_kfv msbk1,

9762: THEN
9763: SELECT COUNT (*)
9764: INTO l_no_access_comp_cnt
9765: FROM bom_components_b bcb,
9766: mtl_system_items_b_kfv msbk1,
9767: bom_copy_explosions_v bev
9768: WHERE bcb.bill_sequence_id = x_from_sequence_id
9769: AND bcb.component_item_id = msbk1.inventory_item_id
9770: AND bcb.component_item_id <> to_item_id

Line 9867: mtl_system_items_b_kfv msbk1,

9863: NULL,
9864: fnd_global.conc_program_id,
9865: sysdate
9866: FROM bom_components_b bcb,
9867: mtl_system_items_b_kfv msbk1,
9868: bom_copy_explosions_v bev
9869: WHERE msbk1.inventory_item_id = from_item_id
9870: AND msbk1.organization_id = from_org_id
9871: AND bcb.component_sequence_id = bev.component_sequence_id