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.WSMPPCPD dependencies on BOM_BILL_OF_MATERIALS

Line 870: FROM bom_bill_of_materials bbom

866: BEGIN
867:
868: SELECT 1
869: INTO x_dummy
870: FROM bom_bill_of_materials bbom
871: WHERE bbom.common_bill_sequence_id = x_bill_sequence_id
872: AND bbom.organization_id <> x_org_id
873: AND NOT EXISTS (
874: SELECT null

Line 1002: FROM bom_bill_of_materials bbom

998: BEGIN
999:
1000: SELECT 1
1001: INTO x_dummy
1002: FROM bom_bill_of_materials bbom
1003: WHERE bbom.common_bill_sequence_id = x_bill_sequence_id
1004: AND bbom.organization_id <> x_org_id
1005: AND NOT EXISTS
1006: (SELECT null

Line 1365: FROM bom_bill_of_materials bbom

1361: BEGIN
1362:
1363: SELECT 1
1364: INTO x_dummy
1365: FROM bom_bill_of_materials bbom
1366: WHERE bbom.common_bill_sequence_id = rec.bill_sequence_id
1367: AND bbom.organization_id <> x_org_id
1368: AND NOT EXISTS (
1369: SELECT null

Line 1470: FROM bom_bill_of_materials bbom

1466: BEGIN
1467:
1468: SELECT 1
1469: INTO x_dummy
1470: FROM bom_bill_of_materials bbom
1471: WHERE bbom.common_bill_sequence_id = rec.bill_sequence_id
1472: AND bbom.organization_id <> x_org_id
1473: AND NOT EXISTS
1474: (SELECT null

Line 1759: FROM bom_bill_of_materials bbom

1755: SELECT bbom.bill_sequence_id,
1756: bbom.common_bill_sequence_id
1757: INTO x_existing_bom,
1758: x_comm_bill_seq_id
1759: FROM bom_bill_of_materials bbom
1760: WHERE bbom.assembly_item_id = x_co_product_id
1761: AND bbom.organization_id = x_org_id
1762: AND bbom.alternate_bom_designator is NULL;
1763:

Line 1827: FROM bom_bill_of_materials bbom

1823: SELECT bbom.bill_sequence_id,
1824: bbom.common_bill_sequence_id
1825: INTO x_existing_bom,
1826: x_comm_bill_seq_id
1827: FROM bom_bill_of_materials bbom
1828: WHERE bbom.assembly_item_id = x_co_product_id
1829: AND bbom.organization_id = x_org_id
1830: AND bbom.alternate_bom_designator = x_alternate_designator;
1831:

Line 1877: ** FROM bom_bill_of_materials bbom

1873: ** SELECT 1
1874: ** INTO x_bom_exists
1875: ** FROM sys.dual
1876: ** WHERE EXISTS (SELECT 1
1877: ** FROM bom_bill_of_materials bbom
1878: ** WHERE bbom.assembly_item_id = x_co_product_id
1879: ** AND bbom.organization_id = x_org_id
1880: ** AND bbom.alternate_bom_designator is NULL);
1881: ** EXCEPTION

Line 1890: FROM bom_bill_of_materials bbom

1886: -- modification begin for perf. tuning.. abedajna 10/12/00
1887:
1888: SELECT 1
1889: INTO x_bom_exists
1890: FROM bom_bill_of_materials bbom
1891: WHERE bbom.assembly_item_id = x_co_product_id
1892: AND bbom.organization_id = x_org_id
1893: AND bbom.alternate_bom_designator is NULL;
1894:

Line 2422: bom_bill_of_materials bom

2418: BEGIN
2419: select bic.effectivity_date
2420: into l_comp_eff_date
2421: from bom_inventory_components bic,
2422: bom_bill_of_materials bom
2423: where bom.bill_sequence_id = x_bill_sequence_id
2424: and bic.bill_sequence_id = bom.common_bill_sequence_id
2425: and bic.component_item_id = x_component_id
2426: and bic.operation_seq_num = 1;

Line 2709: FROM bom_bill_of_materials bbom

2705: x_progress := '030';
2706:
2707: SELECT bbom.common_bill_sequence_id
2708: INTO x_current_comm_bill
2709: FROM bom_bill_of_materials bbom
2710: WHERE bbom.bill_sequence_id = S_rec.bill_sequence_id
2711: AND EXISTS (SELECT 1
2712: FROM wsm_co_products bcp
2713: WHERE bcp.bill_sequence_id = bbom.common_bill_sequence_id

Line 2742: UPDATE bom_bill_of_materials

2738: ELSIF (x_error_code < 0) THEN
2739: raise e_proc_exception;
2740: END IF;
2741:
2742: UPDATE bom_bill_of_materials
2743: SET common_assembly_item_id = x_c_assembly_id,
2744: common_organization_id = x_c_org_id,
2745: common_bill_sequence_id = x_c_bill_seq_id
2746: WHERE bill_sequence_id = S_rec.bill_sequence_id;

Line 2807: FROM bom_bill_of_materials bbom

2803: x_progress := '070';
2804:
2805: SELECT bbom.common_bill_sequence_id
2806: INTO x_current_comm_bill
2807: FROM bom_bill_of_materials bbom
2808: WHERE bbom.bill_sequence_id = x_bill_sequence_id
2809: AND EXISTS (SELECT 1
2810: FROM wsm_co_products bcp
2811: WHERE bcp.bill_sequence_id = bbom.common_bill_sequence_id

Line 2841: UPDATE bom_bill_of_materials

2837: ELSIF (x_error_code < 0) THEN
2838: raise e_proc_exception;
2839: END IF;
2840:
2841: UPDATE bom_bill_of_materials
2842: SET common_assembly_item_id = x_c_assembly_id,
2843: common_organization_id = x_c_org_id,
2844: common_bill_sequence_id = x_c_bill_seq_id
2845: WHERE bill_sequence_id = x_bill_sequence_id;

Line 3086: delete bom_bill_of_materials

3082: -- Now go ahead and delete the BOM Header.
3083:
3084: x_progress := '031';
3085:
3086: delete bom_bill_of_materials
3087: where bill_sequence_id = x_bill_sequence_id;
3088:
3089:
3090: ** If the coproduct is a primary co-product (as in deletion

Line 3331: FROM bom_bill_of_materials

3327:
3328: x_progress VARCHAR2(3) := '010';
3329:
3330: CURSOR C IS SELECT *
3331: FROM bom_bill_of_materials
3332: WHERE bill_sequence_id = x_bill_sequence_id
3333: FOR UPDATE OF bill_sequence_id NOWAIT;
3334:
3335: BEGIN

Line 3564: ** bom_bill_of_materials table.

3560: /*
3561: ** This cursor ensures that the co-products being
3562: ** updated for the common bill sequence Id do exist
3563: ** in BOM as well and hence it is combined with the
3564: ** bom_bill_of_materials table.
3565: ** - Bala Balakumar, June 23rd, 2000.
3566: */
3567:
3568: CURSOR C is

Line 3570: FROM bom_bill_of_materials bbom,

3566: */
3567:
3568: CURSOR C is
3569: SELECT co_product_id, wcp.alternate_designator
3570: FROM bom_bill_of_materials bbom,
3571: wsm_co_products wcp
3572: WHERE wcp.co_product_group_id = p_co_product_group_id
3573: AND wcp.co_product_id IS NOT NULL
3574: AND NVL(wcp.primary_flag, 'N') <> 'Y'