APPS.CSTPSCEX dependencies on CST_SC_SOURCING_RULES

Line 165: insert into CST_SC_SOURCING_RULES

161: -- source_organization_id is null and
162: -- vendor_id is not null.
163: l_stmt_num := 20;
164:
165: insert into CST_SC_SOURCING_RULES
166: (
167: ROLLUP_ID,
168: ASSIGNMENT_SET_ID,
169: INVENTORY_ITEM_ID,

Line 241: from cst_sc_sourcing_rules cssr, mtl_parameters mp

237: l_stmt_num := 30;
238:
239: select cssr.sourcing_rule_name, mp.organization_code
240: into l_sourcing_rule_name, l_organization_code
241: from cst_sc_sourcing_rules cssr, mtl_parameters mp
242: where rollup_id = i_rollup_id
243: and cssr.inventory_item_id = i_inventory_item_id
244: and cssr.organization_id = i_organization_id
245: and cssr.assignment_set_id = i_assignment_set_id

Line 292: cst_sc_sourcing_rules CSSR,

288: SOB_FROM.currency_code from_currency,
289: CSSR.organization_id,
290: SOB_TO.currency_code to_currency
291: from
292: cst_sc_sourcing_rules CSSR,
293: hr_organization_information OOD_FROM,
294: gl_sets_of_books SOB_FROM,
295: hr_organization_information OOD_TO,
296: gl_sets_of_books SOB_TO

Line 317: update cst_sc_sourcing_rules CSSR

313:
314: BEGIN
315: l_stmt_num := 10;
316:
317: update cst_sc_sourcing_rules CSSR
318: set
319: CSSR.conversion_type = i_conversion_type,
320: CSSR.conversion_rate =
321: gl_currency_api.get_rate

Line 512: cst_sc_sourcing_rules CSSR, mtl_system_items msi /* Bug 6124274 */

508: i_prog_appl_id, -- PROGRAM_APPLICATION_ID
509: i_prog_id, -- PROGRAM_ID
510: sysdate -- PROGRAM_UPDATE_DATE
511: from
512: cst_sc_sourcing_rules CSSR, mtl_system_items msi /* Bug 6124274 */
513: where
514: CSSR.rollup_id = i_rollup_id and
515: msi.inventory_item_id = cssr.inventory_item_id and
516: msi.organization_id = cssr.organization_id and

Line 647: from cst_sc_sourcing_rules CSSR

643: ----------------------------------------------------
644: 0 < (
645: select nvl( sum( decode( CSSR.source_type, 2,
646: CSSR.allocation_percent, 0 ) ), 100 )
647: from cst_sc_sourcing_rules CSSR
648: where
649: CSSR.rollup_id = i_rollup_id and
650: CSSR.inventory_item_id = CSBE.component_item_id and
651: CSSR.organization_id = CSBE.component_organization_id

Line 680: from cst_sc_sourcing_rules CSSR

676: = (
677: select CSBE.component_quantity *
678: nvl( sum( decode( CSSR.source_type, 2,
679: CSSR.allocation_percent, 0 ) ) / 100, 1 )
680: from cst_sc_sourcing_rules CSSR
681: where CSSR.rollup_id = CSBE.rollup_id and
682: CSSR.inventory_item_id = CSBE.assembly_item_id and
683: CSSR.organization_id = CSBE.assembly_organization_id
684: )