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 WSM_CO_PRODUCTS

Line 726: FROM wsm_co_products

722: FOR UPDATE OF substitute_component_id NOWAIT;
723:
724: CURSOR C_COPROD IS SELECT component_sequence_id,
725: bill_sequence_id
726: FROM wsm_co_products
727: WHERE co_product_group_id = x_co_product_group_id
728: And co_product_id is NOT NULL;
729:
730: BEGIN

Line 744: FROM wsm_co_products

740:
741: -- modification begin for perf. tuning.. abedajna 10/12/00
742: SELECT 1
743: INTO x_co_prod_exists
744: FROM wsm_co_products
745: WHERE co_product_group_id = x_co_product_group_id
746: AND co_product_id IS NOT NULL;
747:
748: EXCEPTION

Line 805: FROM wsm_co_products

801: SELECT component_sequence_id,
802: bill_sequence_id
803: INTO x_component_sequence_id,
804: x_bill_sequence_id
805: FROM wsm_co_products
806: WHERE co_product_group_id = x_co_product_group_id
807: And co_product_id is NOT NULL
808: AND NVL(primary_flag, 'N') = 'Y';
809:

Line 1210: FROM wsm_co_products

1206: FOR UPDATE OF substitute_component_id NOWAIT;
1207:
1208: CURSOR C_COPROD IS SELECT component_sequence_id,
1209: bill_sequence_id
1210: FROM wsm_co_products
1211: WHERE co_product_group_id = x_co_product_group_id
1212: And co_product_id is NOT NULL
1213: AND component_sequence_id IS NOT NULL;
1214:

Line 1228: FROM wsm_co_products

1224:
1225: -- modification begin for perf. tuning.. abedajna 10/12/00
1226: SELECT 1
1227: INTO x_co_prod_exists
1228: FROM wsm_co_products
1229: WHERE co_product_group_id = x_co_product_group_id
1230: AND co_product_id IS NOT NULL;
1231:
1232: EXCEPTION

Line 2658: FROM wsm_co_products bcp

2654: x_current_comm_bill NUMBER := NULL;
2655:
2656: CURSOR S IS
2657: SELECT bcp.bill_sequence_id
2658: FROM wsm_co_products bcp
2659: WHERE bcp.co_product_group_id = x_co_product_group_id
2660: AND bcp.bill_sequence_id <> x_bill_sequence_id
2661: AND bcp.co_product_id is NOT NULL;
2662:

Line 2712: FROM wsm_co_products bcp

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
2714: AND (bcp.disable_date is NULL
2715: OR bcp.disable_date > sysdate)
2716: AND bcp.co_product_group_id <> x_co_product_group_id);

Line 2768: FROM wsm_co_products bcp

2764: bcp.co_product_id
2765: INTO x_c_bill_seq_id,
2766: x_c_org_id,
2767: x_c_assembly_id
2768: FROM wsm_co_products bcp
2769: WHERE bcp.co_product_group_id = x_co_product_group_id
2770: AND bcp.primary_flag = 'Y'
2771: AND rownum = 1;
2772:

Line 2810: FROM wsm_co_products bcp

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
2812: AND ( bcp.disable_date is NULL
2813: OR bcp.disable_date > sysdate)
2814: AND bcp.co_product_group_id <> x_co_product_group_id);

Line 2903: FROM wsm_co_products bcp

2899: WHERE co_product_group_id = x_co_product_group_id;
2900:
2901: CURSOR S IS
2902: SELECT bcp.co_product_id
2903: FROM wsm_co_products bcp
2904: WHERE bcp.co_product_group_id = x_co_product_group_id
2905: AND bcp.co_product_id is NOT NULL;
2906:
2907: BEGIN

Line 2996: /* -- Obtain information from wsm_co_products. */

2992: (x_co_product_id IS NULL)) THEN
2993: raise e_delete_co_product;
2994: END IF;
2995:
2996: /* -- Obtain information from wsm_co_products. */
2997:
2998: x_progress := '020';
2999: /******
3000: SELECT bcp.component_sequence_id,

Line 3008: FROM wsm_co_products bcp

3004: INTO x_component_sequence_id,
3005: x_component_id,
3006: x_effectivity_date,
3007: x_rowid
3008: FROM wsm_co_products bcp
3009: WHERE bcp.co_product_group_id = x_co_product_group_id
3010: AND bcp.co_product_id = x_co_product_id;
3011: ******/
3012:

Line 3023: FROM wsm_co_products bcp

3019: x_effectivity_date,
3020: x_bill_sequence_id,
3021: x_primary_flag,
3022: x_rowid
3023: FROM wsm_co_products bcp
3024: WHERE bcp.co_product_group_id = x_co_product_group_id
3025: AND bcp.co_product_id = x_co_product_id;
3026:
3027: /* -- Update bill. */

Line 3099: FROM wsm_co_products bcp

3095: If NVL(x_primary_flag, 'N') = 'Y' Then
3096:
3097: SELECT bcp.component_sequence_id
3098: INTO x_component_sequence_id
3099: FROM wsm_co_products bcp
3100: WHERE bcp.co_product_group_id = x_co_product_group_id
3101: AND bcp.co_product_id is not NULL
3102: And NVL(bcp.primary_flag, 'N') = 'Y';
3103:

Line 3230: FROM wsm_co_products bcp

3226: CURSOR S IS
3227: SELECT bcp.co_product_id,
3228: bcp.component_sequence_id,
3229: bcp.split
3230: FROM wsm_co_products bcp
3231: WHERE bcp.co_product_group_id = x_co_product_group_id
3232: AND bcp.co_product_id is NOT NULL;
3233:
3234: BEGIN

Line 3291: UPDATE wsm_co_products

3287: -- co-products.
3288: --
3289: x_progress := '030';
3290:
3291: UPDATE wsm_co_products
3292: SET effectivity_date = x_effectivity_date,
3293: disable_date = x_disable_date,
3294: usage_rate = x_usage_rate,
3295: duality_flag = x_duality_flag

Line 3571: wsm_co_products wcp

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'
3575: AND bbom.assembly_item_id = wcp.co_product_id

Line 3581: from wsm_co_products wcp1

3577: /*coprod enh p2 .45*/
3578: --AND nvl(bbom.alternate_bom_designator, '$%&') = nvl(p_alternate_designator, '$%&')
3579: AND nvl(bbom.alternate_bom_designator, '$%&') = nvl(wcp.alternate_designator, '$%&')
3580: AND nvl(wcp.alternate_designator, '$%&') = (select nvl(wcp1.alternate_designator, '$%&')
3581: from wsm_co_products wcp1
3582: where wcp1.co_product_group_id=p_co_product_group_id
3583: and wcp1.primary_flag='Y')
3584: /*end coprod enh p2 .45*/
3585: AND bbom.common_bill_sequence_id = wcp.bill_sequence_id;

Line 3607: FROM wsm_co_products

3603: Begin
3604:
3605: SELECT co_product_id
3606: INTO l_prim_co_prod_id
3607: FROM wsm_co_products
3608: WHERE co_product_group_id = p_co_product_group_id
3609: AND co_product_id IS NOT NULL
3610: AND nvl(primary_flag, 'N') = 'Y';
3611: