APPS.CSTPSCCM dependencies on MTL_PARAMETERS

Line 462: MTL_PARAMETERS MP

458: NVL(vendor_cur.vendor_site_id, -1),
459: curr_vendor_buy_weight*100
460: FROM
461: CST_ITEM_COST_DETAILS CICD2,
462: MTL_PARAMETERS MP
463: WHERE
464: -- If buy cost type equals destination cost type, do not include rolled-up costs.
465: -- This is to get consistent results with the no-buy-cost-detail option.
466: CICD2.rollup_source_type <> decode(p_buy_cost_type_id, p_dest_cost_type_id, 3, -1) AND

Line 509: FROM MTL_PARAMETERS

505: ***************************************************** */
506: l_stmt_num := 65;
507: SELECT wsm_enabled_flag
508: INTO wsm_flag
509: FROM MTL_PARAMETERS
510: WHERE organization_id = p_dest_organization_id;
511:
512:
513: l_stmt_num := 70;

Line 610: MTL_PARAMETERS MP

606: src_org.allocation_factor*100,
607: src_org.ship_method
608: FROM
609: CST_ITEM_COST_DETAILS CICD2,
610: MTL_PARAMETERS MP
611: WHERE
612: CICD2.inventory_item_id = p_inventory_item_id
613: AND CICD2.organization_id = src_org.source_organization_id
614: AND MP.organization_id = src_org.source_organization_id

Line 740: MTL_PARAMETERS MP

736: src_org.allocation_factor * 100,
737: src_org.ship_method
738: FROM
739: CST_ITEM_COST_DETAILS CICD2,
740: MTL_PARAMETERS MP
741: WHERE
742: CICD2.inventory_item_id = p_inventory_item_id
743: AND CICD2.organization_id = p_dest_organization_id
744: AND CICD2.cost_type_id = p_dest_cost_type_id

Line 803: MTL_PARAMETERS MP

799: src_org.allocation_factor * 100,
800: src_org.ship_method
801: FROM
802: CST_ITEM_COST_DETAILS CICD2,
803: MTL_PARAMETERS MP
804: WHERE
805: CICD2.inventory_item_id = p_inventory_item_id
806: AND CICD2.organization_id = p_dest_organization_id
807: AND CICD2.cost_type_id = p_dest_cost_type_id