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 806: FROM mtl_system_items_b_kfv

802: CURSOR l_org_item_csr (p_item_id IN NUMBER, p_org_id IN NUMBER)
803: IS
804: SELECT concatenated_segments,
805: primary_uom_code
806: FROM mtl_system_items_b_kfv
807: WHERE inventory_item_id = p_item_id
808: AND organization_id = p_org_id;
809:
810: CURSOR getcurrentminorrevcode (

Line 3817: mtl_system_items_b_kfv msbk1,

3813:
3814: SELECT COUNT (*)
3815: INTO l_no_access_comp_cnt
3816: FROM bom_components_b bcb,
3817: mtl_system_items_b_kfv msbk1,
3818: bom_copy_explosions_v bev
3819: WHERE bcb.bill_sequence_id = x_from_sequence_id
3820: AND bcb.component_item_id = msbk1.inventory_item_id
3821: AND bcb.component_item_id <> to_item_id

Line 3904: FROM mtl_system_items_b_kfv msbk1

3900: fnd_global.conc_request_id,
3901: NULL,
3902: fnd_global.conc_program_id,
3903: sysdate
3904: FROM mtl_system_items_b_kfv msbk1
3905: WHERE msbk1.inventory_item_id = from_item_id
3906: AND msbk1.organization_id = from_org_id;
3907: END IF;
3908:

Line 3914: mtl_system_items_b_kfv msbk1,

3910: THEN
3911: SELECT COUNT (*)
3912: INTO l_no_access_comp_cnt
3913: FROM bom_components_b bcb,
3914: mtl_system_items_b_kfv msbk1,
3915: bom_copy_explosions_v bev
3916: WHERE bcb.bill_sequence_id = x_from_sequence_id
3917: AND bcb.component_item_id = msbk1.inventory_item_id
3918: AND bcb.component_item_id <> to_item_id

Line 4001: FROM mtl_system_items_b_kfv msbk1

3997: fnd_global.conc_request_id,
3998: NULL,
3999: fnd_global.conc_program_id,
4000: sysdate
4001: FROM mtl_system_items_b_kfv msbk1
4002: WHERE msbk1.inventory_item_id = from_item_id
4003: AND msbk1.organization_id = from_org_id;
4004: END IF;
4005: END IF;

Line 4220: mtl_system_items_b_kfv msbk1,

4216: SYSDATE,
4217: user_id,
4218: 'E'
4219: FROM bom_components_b bcb,
4220: mtl_system_items_b_kfv msbk1,
4221: mtl_system_items_b_kfv msbk2,
4222: bom_copy_explosions_v bev
4223: WHERE bcb.bill_sequence_id = x_from_sequence_id
4224: AND bcb.component_item_id = msbk1.inventory_item_id

Line 4221: mtl_system_items_b_kfv msbk2,

4217: user_id,
4218: 'E'
4219: FROM bom_components_b bcb,
4220: mtl_system_items_b_kfv msbk1,
4221: mtl_system_items_b_kfv msbk2,
4222: bom_copy_explosions_v bev
4223: WHERE bcb.bill_sequence_id = x_from_sequence_id
4224: AND bcb.component_item_id = msbk1.inventory_item_id
4225: AND bcb.component_item_id <> to_item_id

Line 6413: FROM mtl_system_items_b_kfv msbk

6409: FOR component_rec IN c_component_cur (p_sort_order, p_explode_grp_id)
6410: LOOP
6411: SELECT concatenated_segments
6412: INTO l_component_name
6413: FROM mtl_system_items_b_kfv msbk
6414: WHERE msbk.inventory_item_id = component_rec.component_item_id
6415: AND msbk.organization_id = p_org_id;
6416:
6417: IF (l_component_path IS NULL)

Line 6515: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;

6511: l_error_tbl inv_item_grp.error_tbl_type;
6512: x_msg_list error_handler.error_tbl_type;
6513: l_item_org_assign_tbl system.EGO_ITEM_ORG_ASSIGN_TABLE := new system.EGO_ITEM_ORG_ASSIGN_TABLE();
6514: l_trgt_item_uom_code mtl_system_items_b.primary_uom_code%TYPE;
6515: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6516: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6517: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6518: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6519: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;

Line 6516: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;

6512: x_msg_list error_handler.error_tbl_type;
6513: l_item_org_assign_tbl system.EGO_ITEM_ORG_ASSIGN_TABLE := new system.EGO_ITEM_ORG_ASSIGN_TABLE();
6514: l_trgt_item_uom_code mtl_system_items_b.primary_uom_code%TYPE;
6515: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6516: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6517: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6518: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6519: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6520: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;

Line 6517: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;

6513: l_item_org_assign_tbl system.EGO_ITEM_ORG_ASSIGN_TABLE := new system.EGO_ITEM_ORG_ASSIGN_TABLE();
6514: l_trgt_item_uom_code mtl_system_items_b.primary_uom_code%TYPE;
6515: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6516: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6517: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6518: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6519: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6520: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;
6521: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;

Line 6518: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;

6514: l_trgt_item_uom_code mtl_system_items_b.primary_uom_code%TYPE;
6515: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6516: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6517: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6518: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6519: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6520: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;
6521: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;
6522: l_not_exists NUMBER := 0;

Line 6519: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;

6515: l_trgt_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
6516: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6517: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6518: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6519: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6520: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;
6521: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;
6522: l_not_exists NUMBER := 0;
6523: l_msg_count NUMBER := 0;

Line 6520: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;

6516: l_secondary_uom_code mtl_system_items_b_kfv.secondary_uom_code%TYPE;
6517: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6518: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6519: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6520: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;
6521: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;
6522: l_not_exists NUMBER := 0;
6523: l_msg_count NUMBER := 0;
6524: l_item_count NUMBER := 1;

Line 6521: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;

6517: l_dual_uom_deviation_high mtl_system_items_b_kfv.dual_uom_deviation_high%TYPE;
6518: l_dual_uom_deviation_low mtl_system_items_b_kfv.dual_uom_deviation_low%TYPE;
6519: l_secondary_default_ind mtl_system_items_b_kfv.secondary_default_ind%TYPE;
6520: l_tracking_quantity_ind mtl_system_items_b_kfv.tracking_quantity_ind%TYPE;
6521: l_ont_pricing_qty_source mtl_system_items_b_kfv.ont_pricing_qty_source%TYPE;
6522: l_not_exists NUMBER := 0;
6523: l_msg_count NUMBER := 0;
6524: l_item_count NUMBER := 1;
6525: l_index NUMBER := 0;

Line 6544: FROM mtl_system_items_b_kfv msibk,

6540: msibk.dual_uom_deviation_low,
6541: msibk.secondary_default_ind,
6542: msibk.tracking_quantity_ind,
6543: msibk.ont_pricing_qty_source
6544: FROM mtl_system_items_b_kfv msibk,
6545: bom_copy_explosions_v bev
6546: WHERE msibk.inventory_item_id = bev.component_item_id
6547: AND msibk.organization_id = bev.organization_id
6548: AND (bev.implementation_date IS NOT NULL

Line 6605: FROM mtl_system_items_b_kfv mmsib

6601: IS
6602: SELECT mmsib.primary_uom_code, 1 l_not_exists, concatenated_segments,
6603: mmsib.secondary_uom_code, mmsib.dual_uom_deviation_high, mmsib.dual_uom_deviation_low,
6604: mmsib.secondary_default_ind, mmsib.tracking_quantity_ind, mmsib.ont_pricing_qty_source
6605: FROM mtl_system_items_b_kfv mmsib
6606: WHERE mmsib.inventory_item_id = p_item_id
6607: AND mmsib.organization_id = p_master_org_id
6608: AND NOT EXISTS
6609: ( SELECT 1

Line 7430: FROM mtl_system_items_b_kfv

7426: CURSOR l_org_item_csr (p_item_id IN NUMBER, p_org_id IN NUMBER)
7427: IS
7428: SELECT concatenated_segments,
7429: primary_uom_code
7430: FROM mtl_system_items_b_kfv
7431: WHERE inventory_item_id = p_item_id
7432: AND organization_id = p_org_id;
7433:
7434: CURSOR l_from_to_comps_csr (

Line 9790: mtl_system_items_b_kfv msbk1,

9786:
9787: SELECT COUNT (*)
9788: INTO l_no_access_comp_cnt
9789: FROM bom_components_b bcb,
9790: mtl_system_items_b_kfv msbk1,
9791: bom_copy_explosions_v bev
9792: WHERE bcb.bill_sequence_id = x_from_sequence_id
9793: AND bcb.component_item_id = msbk1.inventory_item_id
9794: AND bcb.component_item_id <> to_item_id

Line 9891: mtl_system_items_b_kfv msbk1,

9887: NULL,
9888: fnd_global.conc_program_id,
9889: sysdate
9890: FROM bom_components_b bcb,
9891: mtl_system_items_b_kfv msbk1,
9892: bom_copy_explosions_v bev
9893: WHERE msbk1.inventory_item_id = from_item_id
9894: AND msbk1.organization_id = from_org_id
9895: AND bcb.component_sequence_id = bev.component_sequence_id

Line 9919: mtl_system_items_b_kfv msbk1,

9915: THEN
9916: SELECT COUNT (*)
9917: INTO l_no_access_comp_cnt
9918: FROM bom_components_b bcb,
9919: mtl_system_items_b_kfv msbk1,
9920: bom_copy_explosions_v bev
9921: WHERE bcb.bill_sequence_id = x_from_sequence_id
9922: AND bcb.component_item_id = msbk1.inventory_item_id
9923: AND bcb.component_item_id <> to_item_id

Line 10020: mtl_system_items_b_kfv msbk1,

10016: NULL,
10017: fnd_global.conc_program_id,
10018: sysdate
10019: FROM bom_components_b bcb,
10020: mtl_system_items_b_kfv msbk1,
10021: bom_copy_explosions_v bev
10022: WHERE msbk1.inventory_item_id = from_item_id
10023: AND msbk1.organization_id = from_org_id
10024: AND bcb.component_sequence_id = bev.component_sequence_id