APPS.GMF_CMCOMMON dependencies on CM_CMPT_DTL

Line 1773: FROM cm_cmpt_dtl cst,

1769: l_batch_id IN gme_batch_header.batch_id%TYPE
1770: )
1771: IS
1772: SELECT count(1)
1773: FROM cm_cmpt_dtl cst,
1774: cm_acst_led aled,
1775: gme_material_details md,
1776: gme_batch_header bh
1777: WHERE bh.batch_id = l_batch_id

Line 2215: l_cost_component_class_id CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;

2211: l_msg_data VARCHAR2(2000);
2212: l_total_cost NUMBER;
2213: l_no_of_rows NUMBER(10);
2214: l_cost_method CM_MTHD_MST.COST_MTHD_CODE%TYPE;
2215: l_cost_component_class_id CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;
2216: l_cost_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;
2217: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Unit_Cost' ;
2218: l_api_version CONSTANT NUMBER := 1.0 ;
2219:

Line 2216: l_cost_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;

2212: l_total_cost NUMBER;
2213: l_no_of_rows NUMBER(10);
2214: l_cost_method CM_MTHD_MST.COST_MTHD_CODE%TYPE;
2215: l_cost_component_class_id CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;
2216: l_cost_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;
2217: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Unit_Cost' ;
2218: l_api_version CONSTANT NUMBER := 1.0 ;
2219:
2220: /********************************************

Line 2344: l_cost_component_class_id CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;

2340: l_msg_data VARCHAR2(2000);
2341: l_total_cost NUMBER;
2342: l_no_of_rows NUMBER(10);
2343: l_cost_method CM_MTHD_MST.COST_MTHD_CODE%TYPE;
2344: l_cost_component_class_id CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;
2345: l_cost_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;
2346: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Unit_Cost' ;
2347: l_api_version CONSTANT NUMBER := 1.0 ;
2348:

Line 2345: l_cost_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;

2341: l_total_cost NUMBER;
2342: l_no_of_rows NUMBER(10);
2343: l_cost_method CM_MTHD_MST.COST_MTHD_CODE%TYPE;
2344: l_cost_component_class_id CM_CMPT_DTL.COST_CMPNTCLS_ID%TYPE;
2345: l_cost_analysis_code CM_CMPT_DTL.COST_ANALYSIS_CODE%TYPE;
2346: l_api_name CONSTANT VARCHAR2(30) := 'Process_Item_Unit_Cost' ;
2347: l_api_version CONSTANT NUMBER := 1.0 ;
2348:
2349: /********************************************

Line 2450: * This function gets item unit cost from cm_cmpt_dtl, NOT from gl_item_cst/dtl.

2446: * FUNCTION
2447: * get_cmpt_cost
2448: * DESCRIPTION
2449: *
2450: * This function gets item unit cost from cm_cmpt_dtl, NOT from gl_item_cst/dtl.
2451: * This is being use in OPM Batch Cost Detail Report.
2452: *
2453: * AUTHOR
2454: * Anand Thiyagarajan 20-Feb-2007 Bug#5436964 Batches Across Periods FP

Line 2491: FROM cm_cmpt_dtl cst,

2487: v_cost_type_id NUMBER
2488: )
2489: IS
2490: SELECT nvl(sum(cst.cmpnt_cost), 0)
2491: FROM cm_cmpt_dtl cst,
2492: gmf_organization_definitions god,
2493: gmf_fiscal_policies f,
2494: gmf_period_statuses gps,
2495: (