DBA Data[Home] [Help]

APPS.CTO_CONFIG_COST_PK dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 1093: c_po_valid_org financials_system_params_all.inventory_organization_id%type ;

1089: c_config_item_id bom_cto_src_orgs.model_item_id%type ;
1090: c_match_config_item_id bom_cto_src_orgs.model_item_id%type ;
1091: c_org_id bom_cto_src_orgs.rcv_org_id%type ;
1092: c_organization_id bom_cto_src_orgs.organization_id%type ;
1093: c_po_valid_org financials_system_params_all.inventory_organization_id%type ;
1094: c_oper_unit inv_organization_info_v.operating_unit%type ;
1095:
1096: v_buy_item_cost mtl_system_items.list_price_per_unit%type ;
1097:

Line 1490: from financials_system_params_All

1486: lStmtNumber := 29.2;
1487:
1488: Select nvl(inventory_organization_id,0)
1489: into c_po_valid_org
1490: from financials_system_params_All
1491: where org_id = c_oper_unit;
1492:
1493:
1494: IF PG_DEBUG <> 0 THEN

Line 2105: c_po_valid_org financials_system_params_all.inventory_organization_id%type ;

2101: c_model_item_id bom_cto_src_orgs.model_item_id%type ;
2102: c_config_item_id bom_cto_src_orgs.model_item_id%type ;
2103: c_cost_org_id mtl_parameters.cost_organization_id%type ; -- 3116778
2104: c_organization_id bom_cto_src_orgs.organization_id%type ;
2105: c_po_valid_org financials_system_params_all.inventory_organization_id%type ;
2106: c_oper_unit inv_organization_info_v.operating_unit%type ;
2107:
2108: v_buy_item_cost mtl_system_items.list_price_per_unit%type ;
2109:

Line 2123: , financials_system_params_all fsp

2119: , nvl(fsp.inventory_organization_id,0) po_valid_org
2120: , nvl(org.operating_unit,0) oper_unit
2121: from bom_cto_src_orgs bcso
2122: , bom_cto_order_lines bcol
2123: , financials_system_params_all fsp
2124: , inv_organization_info_v org
2125: , cst_item_costs cic
2126: , mtl_parameters mp1 /* master organization */
2127: , mtl_parameters mp2