DBA Data[Home] [Help]

APPS.JAI_RCV_ACCOUNTING_PKG dependencies on CST_ITEM_COST_DETAILS

Line 1017: || FROM cst_item_cost_details

1013: /*
1014: || Commented by vkaranam for Bug 5186391
1015: ||
1016: || SELECT count(1)
1017: || FROM cst_item_cost_details
1018: || WHERE inventory_item_id = cp_item_id
1019: || AND organization_id = cp_organization_id
1020: || AND cost_element_id = 2 --Indicates Material OverHead
1021: || AND basis_type = 5 --Total Value Basis

Line 1029: FROM cst_item_cost_details a, bom_resources b

1025: || ); */
1026:
1027: CURSOR c_fetch_overhead_rate(cp_organization_id in number, cp_item_id in number) IS
1028: SELECT a.resource_id, a.usage_rate_or_amount, b.absorption_account
1029: FROM cst_item_cost_details a, bom_resources b
1030: WHERE a.resource_id = b.resource_id
1031: AND a.organization_id = cp_organization_id
1032: AND a.inventory_item_id = cp_item_id
1033: AND a.cost_element_id = 2 --Indicates Material OverHead