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 702: FROM DUAL

698:
699: CURSOR l_common_csr
700: IS
701: SELECT 1
702: FROM DUAL
703: WHERE EXISTS (
704: SELECT NULL
705: FROM bom_structures_b bom,
706: bom_inventory_components bic

Line 1437: FROM dual;

1433: fnd_global.conc_request_id,
1434: NULL,
1435: fnd_global.conc_program_id,
1436: sysdate
1437: FROM dual;
1438: l_msg_count := l_error_msg_tbl.next(l_msg_count);
1439: END LOOP;
1440: END IF;
1441: END IF;

Line 1820: FROM DUAL

1816: AND msibs.organization_id = to_org_id
1817: AND ecv.value_varchar2 = msi.item_type -- Component
1818: UNION ALL
1819: SELECT 1
1820: FROM DUAL
1821: WHERE NOT EXISTS
1822: (
1823: SELECT 1
1824: FROM fnd_lookup_values_vl flv,

Line 2220: FROM DUAL

2216: AND msibs.organization_id = to_org_id
2217: AND ecv.value_varchar2 = msi.item_type -- Component
2218: UNION ALL
2219: SELECT 1
2220: FROM DUAL
2221: WHERE NOT EXISTS
2222: (
2223: SELECT 1
2224: FROM fnd_lookup_values_vl flv,

Line 2697: FROM DUAL

2693: AND msibs.organization_id = to_org_id
2694: AND ecv.value_varchar2 = msi.item_type -- Component
2695: UNION ALL
2696: SELECT 1
2697: FROM DUAL
2698: WHERE NOT EXISTS
2699: (
2700: SELECT 1
2701: FROM fnd_lookup_values_vl flv,

Line 3139: FROM DUAL

3135: AND msibs.organization_id = to_org_id
3136: AND ecv.value_varchar2 = msi.item_type -- Component
3137: UNION ALL
3138: SELECT 1
3139: FROM DUAL
3140: WHERE NOT EXISTS
3141: (
3142: SELECT 1
3143: FROM fnd_lookup_values_vl flv,

Line 3590: FROM DUAL

3586: AND msibs.organization_id = to_org_id
3587: AND ecv.value_varchar2 = msi.item_type -- Component
3588: UNION ALL
3589: SELECT 1
3590: FROM DUAL
3591: WHERE NOT EXISTS
3592: (
3593: SELECT 1
3594: FROM fnd_lookup_values_vl flv,

Line 5845: FROM DUAL

5841: AND msibs.organization_id = to_org_id
5842: AND ecv.value_varchar2 = msi.item_type -- Substitute Component
5843: UNION ALL
5844: SELECT 1
5845: FROM DUAL
5846: WHERE NOT EXISTS
5847: (
5848: SELECT 1
5849: FROM fnd_lookup_values_vl flv,

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

6535: -- c_org_id organization_id,
6536: -- c_org_code organization_code,
6537: msibk.primary_uom_code,
6538: msibk.secondary_uom_code,
6539: msibk.dual_uom_deviation_high,
6540: msibk.dual_uom_deviation_low,
6541: msibk.secondary_default_ind,
6542: msibk.tracking_quantity_ind,
6543: msibk.ont_pricing_qty_source

Line 6540: msibk.dual_uom_deviation_low,

6536: -- c_org_code organization_code,
6537: msibk.primary_uom_code,
6538: msibk.secondary_uom_code,
6539: msibk.dual_uom_deviation_high,
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,

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

6599: p_master_org_id IN NUMBER,
6600: p_org_id IN NUMBER )
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

Line 6630: l_secondary_uom_code, l_dual_uom_deviation_high, l_dual_uom_deviation_low,

6626:
6627: LOOP
6628: FETCH l_uom_in_master_org_csr
6629: INTO l_trgt_item_uom_code, l_not_exists, l_trgt_item_name,
6630: l_secondary_uom_code, l_dual_uom_deviation_high, l_dual_uom_deviation_low,
6631: l_secondary_default_ind, l_tracking_quantity_ind, l_ont_pricing_qty_source;
6632:
6633: EXIT WHEN l_uom_in_master_org_csr%NOTFOUND;
6634: END LOOP;

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

6643: l_item_org_assign_tbl(l_item_count).organization_code := p_to_org_code;
6644: l_item_org_assign_tbl(l_item_count).primary_uom_code := l_trgt_item_uom_code;
6645: l_item_org_assign_tbl(l_item_count).inventory_item_id := p_to_item_id;
6646: l_item_org_assign_tbl(l_item_count).secondary_uom_code := l_secondary_uom_code;
6647: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_high := l_dual_uom_deviation_high;
6648: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_low := l_dual_uom_deviation_low;
6649: l_item_org_assign_tbl(l_item_count).secondary_default_ind := l_secondary_default_ind;
6650: l_item_org_assign_tbl(l_item_count).tracking_quantity_ind := l_tracking_quantity_ind;
6651: l_item_org_assign_tbl(l_item_count).ont_pricing_qty_source := l_ont_pricing_qty_source;

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

6644: l_item_org_assign_tbl(l_item_count).primary_uom_code := l_trgt_item_uom_code;
6645: l_item_org_assign_tbl(l_item_count).inventory_item_id := p_to_item_id;
6646: l_item_org_assign_tbl(l_item_count).secondary_uom_code := l_secondary_uom_code;
6647: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_high := l_dual_uom_deviation_high;
6648: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_low := l_dual_uom_deviation_low;
6649: l_item_org_assign_tbl(l_item_count).secondary_default_ind := l_secondary_default_ind;
6650: l_item_org_assign_tbl(l_item_count).tracking_quantity_ind := l_tracking_quantity_ind;
6651: l_item_org_assign_tbl(l_item_count).ont_pricing_qty_source := l_ont_pricing_qty_source;
6652: -- l_item_org_assign_tbl(l_item_count).bom_api := 'Y'; -- Not Required. Need to pass p_context for API

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

6668: l_item_org_assign_tbl(l_item_count).organization_code := p_to_org_code;
6669: l_item_org_assign_tbl(l_item_count).primary_uom_code := item_rec.primary_uom_code;
6670: l_item_org_assign_tbl(l_item_count).inventory_item_id := item_rec.inventory_item_id;
6671: l_item_org_assign_tbl(l_item_count).secondary_uom_code := item_rec.secondary_uom_code;
6672: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_high := item_rec.dual_uom_deviation_high;
6673: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_low := item_rec.dual_uom_deviation_low;
6674: l_item_org_assign_tbl(l_item_count).secondary_default_ind := item_rec.secondary_default_ind;
6675: l_item_org_assign_tbl(l_item_count).tracking_quantity_ind := item_rec.tracking_quantity_ind;
6676: l_item_org_assign_tbl(l_item_count).ont_pricing_qty_source := item_rec.ont_pricing_qty_source;

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

6669: l_item_org_assign_tbl(l_item_count).primary_uom_code := item_rec.primary_uom_code;
6670: l_item_org_assign_tbl(l_item_count).inventory_item_id := item_rec.inventory_item_id;
6671: l_item_org_assign_tbl(l_item_count).secondary_uom_code := item_rec.secondary_uom_code;
6672: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_high := item_rec.dual_uom_deviation_high;
6673: l_item_org_assign_tbl(l_item_count).dual_uom_deviation_low := item_rec.dual_uom_deviation_low;
6674: l_item_org_assign_tbl(l_item_count).secondary_default_ind := item_rec.secondary_default_ind;
6675: l_item_org_assign_tbl(l_item_count).tracking_quantity_ind := item_rec.tracking_quantity_ind;
6676: l_item_org_assign_tbl(l_item_count).ont_pricing_qty_source := item_rec.ont_pricing_qty_source;
6677: l_item_count := l_item_count + 1; -- As of now one item at a time

Line 7328: FROM DUAL

7324:
7325: CURSOR l_common_csr
7326: IS
7327: SELECT 1
7328: FROM DUAL
7329: WHERE EXISTS (
7330: SELECT NULL
7331: FROM bom_structures_b bom,
7332: bom_inventory_components bic

Line 8105: FROM DUAL

8101: AND msibs.organization_id = to_org_id
8102: AND ecv.value_varchar2 = msi.item_type -- Component
8103: UNION ALL
8104: SELECT 1
8105: FROM DUAL
8106: WHERE NOT EXISTS
8107: (
8108: SELECT 1
8109: FROM fnd_lookup_values_vl flv,

Line 8474: FROM DUAL

8470: AND msibs.organization_id = to_org_id
8471: AND ecv.value_varchar2 = msi.item_type -- Component
8472: UNION ALL
8473: SELECT 1
8474: FROM DUAL
8475: WHERE NOT EXISTS
8476: (
8477: SELECT 1
8478: FROM fnd_lookup_values_vl flv,

Line 8886: FROM DUAL

8882: AND msibs.organization_id = to_org_id
8883: AND ecv.value_varchar2 = msi.item_type -- Component
8884: UNION ALL
8885: SELECT 1
8886: FROM DUAL
8887: WHERE NOT EXISTS
8888: (
8889: SELECT 1
8890: FROM fnd_lookup_values_vl flv,

Line 9287: FROM DUAL

9283: AND msibs.organization_id = to_org_id
9284: AND ecv.value_varchar2 = msi.item_type -- Component
9285: UNION ALL
9286: SELECT 1
9287: FROM DUAL
9288: WHERE NOT EXISTS
9289: (
9290: SELECT 1
9291: FROM fnd_lookup_values_vl flv,

Line 9675: FROM DUAL

9671: AND msibs.organization_id = to_org_id
9672: AND ecv.value_varchar2 = msi.item_type -- Component
9673: UNION ALL
9674: SELECT 1
9675: FROM DUAL
9676: WHERE NOT EXISTS
9677: (
9678: SELECT 1
9679: FROM fnd_lookup_values_vl flv,

Line 11469: FROM DUAL

11465: AND msibs.organization_id = to_org_id
11466: AND ecv.value_varchar2 = msi.item_type -- Substitute Component
11467: UNION ALL
11468: SELECT 1
11469: FROM DUAL
11470: WHERE NOT EXISTS
11471: (
11472: SELECT 1
11473: FROM fnd_lookup_values_vl flv,