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 DUAL

Line 423: FROM DUAL

419: l_return := 'T';
420:
421: SELECT 'T'
422: INTO l_return
423: FROM DUAL
424: WHERE EXISTS (
425: SELECT revision_id
426: FROM mtl_item_revisions_b
427: WHERE inventory_item_id = p_from_item_id

Line 698: FROM DUAL

694:
695: CURSOR l_common_csr
696: IS
697: SELECT 1
698: FROM DUAL
699: WHERE EXISTS (
700: SELECT NULL
701: FROM bom_structures_b bom,
702: bom_inventory_components bic

Line 1385: FROM dual;

1381: fnd_global.conc_request_id,
1382: NULL,
1383: fnd_global.conc_program_id,
1384: sysdate
1385: FROM dual;
1386: l_msg_count := l_error_msg_tbl.next(l_msg_count);
1387: END LOOP;
1388: END IF;
1389: END IF;

Line 1767: FROM DUAL

1763: AND msibs.organization_id = to_org_id
1764: AND ecv.value_varchar2 = msi.item_type -- Component
1765: UNION ALL
1766: SELECT 1
1767: FROM DUAL
1768: WHERE NOT EXISTS
1769: (
1770: SELECT 1
1771: FROM fnd_lookup_values_vl flv,

Line 2167: FROM DUAL

2163: AND msibs.organization_id = to_org_id
2164: AND ecv.value_varchar2 = msi.item_type -- Component
2165: UNION ALL
2166: SELECT 1
2167: FROM DUAL
2168: WHERE NOT EXISTS
2169: (
2170: SELECT 1
2171: FROM fnd_lookup_values_vl flv,

Line 2644: FROM DUAL

2640: AND msibs.organization_id = to_org_id
2641: AND ecv.value_varchar2 = msi.item_type -- Component
2642: UNION ALL
2643: SELECT 1
2644: FROM DUAL
2645: WHERE NOT EXISTS
2646: (
2647: SELECT 1
2648: FROM fnd_lookup_values_vl flv,

Line 3085: FROM DUAL

3081: AND msibs.organization_id = to_org_id
3082: AND ecv.value_varchar2 = msi.item_type -- Component
3083: UNION ALL
3084: SELECT 1
3085: FROM DUAL
3086: WHERE NOT EXISTS
3087: (
3088: SELECT 1
3089: FROM fnd_lookup_values_vl flv,

Line 3536: FROM DUAL

3532: AND msibs.organization_id = to_org_id
3533: AND ecv.value_varchar2 = msi.item_type -- Component
3534: UNION ALL
3535: SELECT 1
3536: FROM DUAL
3537: WHERE NOT EXISTS
3538: (
3539: SELECT 1
3540: FROM fnd_lookup_values_vl flv,

Line 5753: FROM DUAL

5749: AND msibs.organization_id = to_org_id
5750: AND ecv.value_varchar2 = msi.item_type -- Substitute Component
5751: UNION ALL
5752: SELECT 1
5753: FROM DUAL
5754: WHERE NOT EXISTS
5755: (
5756: SELECT 1
5757: FROM fnd_lookup_values_vl flv,

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 6443: msibk.dual_uom_deviation_high,

6439: -- c_org_id organization_id,
6440: -- c_org_code organization_code,
6441: msibk.primary_uom_code,
6442: msibk.secondary_uom_code,
6443: msibk.dual_uom_deviation_high,
6444: msibk.dual_uom_deviation_low,
6445: msibk.secondary_default_ind,
6446: msibk.tracking_quantity_ind,
6447: msibk.ont_pricing_qty_source

Line 6444: msibk.dual_uom_deviation_low,

6440: -- c_org_code organization_code,
6441: msibk.primary_uom_code,
6442: msibk.secondary_uom_code,
6443: msibk.dual_uom_deviation_high,
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,

Line 6507: mmsib.secondary_uom_code, mmsib.dual_uom_deviation_high, mmsib.dual_uom_deviation_low,

6503: p_master_org_id IN NUMBER,
6504: p_org_id IN NUMBER )
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

Line 6534: l_secondary_uom_code, l_dual_uom_deviation_high, l_dual_uom_deviation_low,

6530:
6531: LOOP
6532: FETCH l_uom_in_master_org_csr
6533: INTO l_trgt_item_uom_code, l_not_exists, l_trgt_item_name,
6534: l_secondary_uom_code, l_dual_uom_deviation_high, l_dual_uom_deviation_low,
6535: l_secondary_default_ind, l_tracking_quantity_ind, l_ont_pricing_qty_source;
6536:
6537: EXIT WHEN l_uom_in_master_org_csr%NOTFOUND;
6538: END LOOP;

Line 6551: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_high := l_dual_uom_deviation_high;

6547: l_item_org_assign_tbl(l_item_count).organization_code := p_to_org_code;
6548: l_item_org_assign_tbl(l_item_count).primary_uom_code := l_trgt_item_uom_code;
6549: l_item_org_assign_tbl(l_item_count).inventory_item_id := p_to_item_id;
6550: l_item_org_assign_tbl(l_item_count).secondary_uom_code := l_secondary_uom_code;
6551: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_high := l_dual_uom_deviation_high;
6552: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_low := l_dual_uom_deviation_low;
6553: l_item_org_assign_tbl(l_item_count).secondary_default_ind := l_secondary_default_ind;
6554: l_item_org_assign_tbl(l_item_count).tracking_quantity_ind := l_tracking_quantity_ind;
6555: l_item_org_assign_tbl(l_item_count).ont_pricing_qty_source := l_ont_pricing_qty_source;

Line 6552: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_low := l_dual_uom_deviation_low;

6548: l_item_org_assign_tbl(l_item_count).primary_uom_code := l_trgt_item_uom_code;
6549: l_item_org_assign_tbl(l_item_count).inventory_item_id := p_to_item_id;
6550: l_item_org_assign_tbl(l_item_count).secondary_uom_code := l_secondary_uom_code;
6551: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_high := l_dual_uom_deviation_high;
6552: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_low := l_dual_uom_deviation_low;
6553: l_item_org_assign_tbl(l_item_count).secondary_default_ind := l_secondary_default_ind;
6554: l_item_org_assign_tbl(l_item_count).tracking_quantity_ind := l_tracking_quantity_ind;
6555: l_item_org_assign_tbl(l_item_count).ont_pricing_qty_source := l_ont_pricing_qty_source;
6556: -- l_item_org_assign_tbl(l_item_count).bom_api := 'Y'; -- Not Required. Need to pass p_context for API

Line 6576: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_high := item_rec.dual_uom_deviation_high;

6572: l_item_org_assign_tbl(l_item_count).organization_code := p_to_org_code;
6573: l_item_org_assign_tbl(l_item_count).primary_uom_code := item_rec.primary_uom_code;
6574: l_item_org_assign_tbl(l_item_count).inventory_item_id := item_rec.inventory_item_id;
6575: l_item_org_assign_tbl(l_item_count).secondary_uom_code := item_rec.secondary_uom_code;
6576: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_high := item_rec.dual_uom_deviation_high;
6577: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_low := item_rec.dual_uom_deviation_low;
6578: l_item_org_assign_tbl(l_item_count).secondary_default_ind := item_rec.secondary_default_ind;
6579: l_item_org_assign_tbl(l_item_count).tracking_quantity_ind := item_rec.tracking_quantity_ind;
6580: l_item_org_assign_tbl(l_item_count).ont_pricing_qty_source := item_rec.ont_pricing_qty_source;

Line 6577: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_low := item_rec.dual_uom_deviation_low;

6573: l_item_org_assign_tbl(l_item_count).primary_uom_code := item_rec.primary_uom_code;
6574: l_item_org_assign_tbl(l_item_count).inventory_item_id := item_rec.inventory_item_id;
6575: l_item_org_assign_tbl(l_item_count).secondary_uom_code := item_rec.secondary_uom_code;
6576: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_high := item_rec.dual_uom_deviation_high;
6577: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_low := item_rec.dual_uom_deviation_low;
6578: l_item_org_assign_tbl(l_item_count).secondary_default_ind := item_rec.secondary_default_ind;
6579: l_item_org_assign_tbl(l_item_count).tracking_quantity_ind := item_rec.tracking_quantity_ind;
6580: l_item_org_assign_tbl(l_item_count).ont_pricing_qty_source := item_rec.ont_pricing_qty_source;
6581: l_item_count := l_item_count + 1; -- As of now one item at a time

Line 7228: FROM DUAL

7224:
7225: CURSOR l_common_csr
7226: IS
7227: SELECT 1
7228: FROM DUAL
7229: WHERE EXISTS (
7230: SELECT NULL
7231: FROM bom_structures_b bom,
7232: bom_inventory_components bic

Line 7964: FROM DUAL

7960: AND msibs.organization_id = to_org_id
7961: AND ecv.value_varchar2 = msi.item_type -- Component
7962: UNION ALL
7963: SELECT 1
7964: FROM DUAL
7965: WHERE NOT EXISTS
7966: (
7967: SELECT 1
7968: FROM fnd_lookup_values_vl flv,

Line 8332: FROM DUAL

8328: AND msibs.organization_id = to_org_id
8329: AND ecv.value_varchar2 = msi.item_type -- Component
8330: UNION ALL
8331: SELECT 1
8332: FROM DUAL
8333: WHERE NOT EXISTS
8334: (
8335: SELECT 1
8336: FROM fnd_lookup_values_vl flv,

Line 8743: FROM DUAL

8739: AND msibs.organization_id = to_org_id
8740: AND ecv.value_varchar2 = msi.item_type -- Component
8741: UNION ALL
8742: SELECT 1
8743: FROM DUAL
8744: WHERE NOT EXISTS
8745: (
8746: SELECT 1
8747: FROM fnd_lookup_values_vl flv,

Line 9143: FROM DUAL

9139: AND msibs.organization_id = to_org_id
9140: AND ecv.value_varchar2 = msi.item_type -- Component
9141: UNION ALL
9142: SELECT 1
9143: FROM DUAL
9144: WHERE NOT EXISTS
9145: (
9146: SELECT 1
9147: FROM fnd_lookup_values_vl flv,

Line 9530: FROM DUAL

9526: AND msibs.organization_id = to_org_id
9527: AND ecv.value_varchar2 = msi.item_type -- Component
9528: UNION ALL
9529: SELECT 1
9530: FROM DUAL
9531: WHERE NOT EXISTS
9532: (
9533: SELECT 1
9534: FROM fnd_lookup_values_vl flv,

Line 11316: FROM DUAL

11312: AND msibs.organization_id = to_org_id
11313: AND ecv.value_varchar2 = msi.item_type -- Substitute Component
11314: UNION ALL
11315: SELECT 1
11316: FROM DUAL
11317: WHERE NOT EXISTS
11318: (
11319: SELECT 1
11320: FROM fnd_lookup_values_vl flv,