DBA Data[Home] [Help]

APPS.JAI_RCV_ACCOUNTING_PKG dependencies on CST_ITEM_COST_DETAILS

Line 1074: FROM cst_item_cost_details

1070: /*
1071: Commented by vkaranam for Bug 5186391 */
1072: --added by vkaranam for bug#9441529
1073: SELECT count(1)
1074: FROM cst_item_cost_details
1075: WHERE inventory_item_id = cp_item_id
1076: AND organization_id = cp_organization_id
1077: AND cost_element_id = 2 --Indicates Material OverHead
1078: AND basis_type = 5 --Total Value Basis

Line 1086: FROM cst_item_cost_details a, bom_resources b

1082: );
1083:
1084: CURSOR c_fetch_overhead_rate(cp_organization_id in number, cp_item_id in number) IS
1085: SELECT a.resource_id, a.usage_rate_or_amount, b.absorption_account
1086: FROM cst_item_cost_details a, bom_resources b
1087: WHERE a.resource_id = b.resource_id
1088: AND a.organization_id = cp_organization_id
1089: AND a.inventory_item_id = cp_item_id
1090: AND a.cost_element_id = 2 --Indicates Material OverHead