APPS.CSTPSCCR dependencies on CST_SC_SOURCING_RULES

Line 2448: CST_SC_SOURCING_RULES CSSR

2444: l_assignment_set_id IN NUMBER) IS
2445: SELECT
2446: CSSR.source_organization_id
2447: FROM
2448: CST_SC_SOURCING_RULES CSSR
2449: WHERE
2450: CSSR.ROLLUP_ID = l_rollup_id
2451: AND CSSR.inventory_item_id = l_inventory_item_id
2452: AND CSSR.organization_id = l_dest_organization_id

Line 2494: UPDATE CST_SC_SOURCING_RULES CSSR

2490: RAISE STANDARD_ERROR;
2491: NULL;
2492: END IF;
2493:
2494: UPDATE CST_SC_SOURCING_RULES CSSR
2495: SET CSSR.MARKUP = l_markup,
2496: CSSR.MARKUP_CODE = l_markup_code
2497: WHERE CSSR.ROLLUP_ID = l_rollup_id
2498: AND CSSR.inventory_item_id = l_item_id

Line 2507: UPDATE CST_SC_SOURCING_RULES

2503: AND l_markup_code <> -1
2504: AND l_markup_code IN (2,3); -- Req value or percent only
2505:
2506:
2507: UPDATE CST_SC_SOURCING_RULES
2508: SET (MARKUP,
2509: MARKUP_CODE) =
2510: (SELECT
2511: INTERORG_TRNSFR_CHARGE_PERCENT,

Line 2573: CST_SC_SOURCING_RULES CSSR

2569: SELECT
2570: CSSR.source_organization_id,
2571: CSSR.ship_method
2572: FROM
2573: CST_SC_SOURCING_RULES CSSR
2574: WHERE
2575: CSSR.ROLLUP_ID = l_rollup_id
2576: AND CSSR.inventory_item_id = l_inventory_item_id
2577: AND CSSR.organization_id = l_dest_organization_id

Line 2621: UPDATE CST_SC_SOURCING_RULES CSSR

2617: NULL;
2618: END IF;
2619: l_stmt_num := 30;
2620:
2621: UPDATE CST_SC_SOURCING_RULES CSSR
2622: SET CSSR.SHIP_CHARGE = x_ship_charge,
2623: CSSR.SHIP_CHARGE_CODE = x_ship_charge_code
2624: WHERE CSSR.ROLLUP_ID = l_rollup_id
2625: AND CSSR.inventory_item_id = l_item_id

Line 2681: CST_SC_SOURCING_RULES CSSR

2677: CSSR.vendor_id,
2678: CSSR.vendor_site_id,
2679: CSSR.ship_method
2680: FROM
2681: CST_SC_SOURCING_RULES CSSR
2682: WHERE
2683: CSSR.ROLLUP_ID = l_rollup_id
2684: AND CSSR.inventory_item_id = l_inventory_item_id
2685: AND CSSR.organization_id = l_dest_organization_id

Line 2719: UPDATE CST_SC_SOURCING_RULES CSSR

2715: NULL;
2716: RAISE STANDARD_ERROR;
2717: END IF;
2718:
2719: UPDATE CST_SC_SOURCING_RULES CSSR
2720: SET CSSR.ITEM_COST = l_buy_cost,
2721: CSSR.BUY_COST_FLAG = 'Y'
2722: WHERE CSSR.ROLLUP_ID = l_rollup_id
2723: AND CSSR.inventory_item_id = l_item_id

Line 2739: UPDATE CST_SC_SOURCING_RULES

2735: INTO default_cost_type_id
2736: FROM CST_COST_TYPES
2737: WHERE COST_TYPE_ID = l_buy_cost_type_id;
2738:
2739: UPDATE CST_SC_SOURCING_RULES
2740: SET (ITEM_COST,
2741: BUY_COST_FLAG) =
2742: (SELECT NVL(SUM(CICD.ITEM_COST),0),
2743: 'Y'

Line 3178: cst_sc_sourcing_rules cssr

3174: (SELECT bic2.BILL_SEQUENCE_ID
3175: FROM BOM_INVENTORY_COMPONENTS bic2,
3176: BOM_BILL_OF_MATERIALS bbom,
3177: CST_SC_LOW_LEVEL_CODES csllc,
3178: cst_sc_sourcing_rules cssr
3179: WHERE csllc.ROLLUP_ID = l_rollup_id
3180: AND cssr.rollup_id (+)= l_rollup_id
3181: AND cssr.inventory_item_id (+)= csllc.inventory_item_id
3182: AND cssr.organization_id (+)= csllc.organization_id

Line 3216: cst_sc_sourcing_rules cssr

3212: (SELECT bbom2.BILL_SEQUENCE_ID
3213: FROM BOM_BILL_OF_MATERIALS bbom2,
3214: CST_SC_LOW_LEVEL_CODES csllc,
3215: cst_item_costs cia,
3216: cst_sc_sourcing_rules cssr
3217: WHERE csllc.ROLLUP_ID = l_rollup_id
3218: AND cssr.rollup_id (+)= l_rollup_id
3219: AND cssr.inventory_item_id (+)= csllc.inventory_item_id
3220: AND cssr.organization_id (+)= csllc.organization_id

Line 3312: cst_sc_sourcing_rules cssr

3308: BOM_INVENTORY_COMPONENTS_S.NEXTVAL
3309: FROM BOM_BILL_OF_MATERIALS bbom,
3310: CST_ITEM_COSTS cia,
3311: CST_SC_LOW_LEVEL_CODES csllc,
3312: cst_sc_sourcing_rules cssr
3313: WHERE csllc.ROLLUP_ID = l_rollup_id
3314: AND cssr.rollup_id(+) = l_rollup_id
3315: AND cssr.inventory_item_id (+)= csllc.inventory_item_id
3316: AND cssr.organization_id (+)= csllc.organization_id

Line 3494: cst_sc_sourcing_rules cssr

3490: BOM_BILL_OF_MATERIALS bbom2,
3491: bom_inventory_components bic,
3492: CST_ITEM_COSTS cia,
3493: CST_SC_LOW_LEVEL_CODES csllc,
3494: cst_sc_sourcing_rules cssr
3495: WHERE csllc.ROLLUP_ID = l_rollup_id
3496: AND cssr.rollup_id(+) = l_rollup_id
3497: AND cssr.inventory_item_id (+)= csllc.inventory_item_id
3498: AND cssr.organization_id (+)= csllc.organization_id

Line 3578: cst_sc_sourcing_rules cssr

3574: set bbom.common_bill_sequence_id = bbom.bill_sequence_id
3575: where EXISTS(
3576: select 1
3577: from cst_sc_low_level_codes csllc,
3578: cst_sc_sourcing_rules cssr
3579: where csllc.rollup_id = l_rollup_id
3580: and cssr.rollup_id(+) = l_rollup_id
3581: and cssr.inventory_item_id (+)= csllc.inventory_item_id
3582: and cssr.organization_id (+)= csllc.organization_id