DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on CM_CMPT_MST

Line 83: * the cost_cmpntcls_id from cm_cmpt_mst table. Used in CMCSDED forms

79: * is 4 or 5 [PPV calculations use retrieve_ind of 4 or 5]. Refer B1019295
80: * Introduced cmcommon_log for printing trace messages
81: * 20-Feb-2002 Uday Moogala Bug# 2231928
82: * Added a new function to get_sort_sequence to return sort_sequence for
83: * the cost_cmpntcls_id from cm_cmpt_mst table. Used in CMCSDED forms
84: * This Level and Lower Level detail blocks ORDER BY property.
85: * 30/Oct/2002 R.Sharath Kumar Bug# 2641405
86: * Added NOCOPY hint
87: * 28-Sep-2001 Venkat Chukkapalli Bug 1926529 - Modified code to use cost

Line 216: * the cost_cmpntcls_id from cm_cmpt_mst table. Used in CMCSDED forms

212: * get_sort_sequence
213: *
214: * DESCRIPTION
215: * This function will return sort_sequence for incomming
216: * the cost_cmpntcls_id from cm_cmpt_mst table. Used in CMCSDED forms
217: * This Level and Lower Level detail blocks ORDER BY property.
218: *
219: * AUTHOR
220: * Uday Moogala 20-Feb-2002 Bug 2231928

Line 237: FROM cm_cmpt_mst

233: IS
234: CURSOR sort_seq(p_ccc_id NUMBER)
235: IS
236: SELECT DECODE(sort_sequence, 0, NULL, sort_sequence) sort_sequence
237: FROM cm_cmpt_mst
238: WHERE cost_cmpntcls_id = p_ccc_id ;
239:
240: l_sort_sequence cm_cmpt_mst.sort_sequence%TYPE;
241:

Line 240: l_sort_sequence cm_cmpt_mst.sort_sequence%TYPE;

236: SELECT DECODE(sort_sequence, 0, NULL, sort_sequence) sort_sequence
237: FROM cm_cmpt_mst
238: WHERE cost_cmpntcls_id = p_ccc_id ;
239:
240: l_sort_sequence cm_cmpt_mst.sort_sequence%TYPE;
241:
242: BEGIN
243:
244: OPEN sort_seq(v_cost_cmpntcls_id) ;

Line 643: cm_cmpt_mst c

639: SELECT cmptcost_amt,
640: i.cost_cmpntcls_id,
641: i.cost_analysis_code
642: FROM gl_item_dtl i,
643: cm_cmpt_mst c
644: WHERE i.itemcost_id = v_itemcost_id
645: AND i.cost_cmpntcls_id = c.cost_cmpntcls_id
646: AND c.ppv_ind = 1;
647:

Line 659: cm_cmpt_mst c

655: )
656: IS
657: SELECT SUM(cmptcost_amt)
658: FROM gl_item_dtl i,
659: cm_cmpt_mst c
660: WHERE i.itemcost_id = v_itemcost_id
661: AND i.cost_cmpntcls_id = c.cost_cmpntcls_id
662: AND c.ppv_ind = 1;
663:

Line 2149: x_cost_component_class_id cm_cmpt_mst.cost_cmpntcls_id%TYPE;

2145: x_msg_data VARCHAR2(2000);
2146: x_no_of_rows NUMBER;
2147:
2148: x_cost_method cm_mthd_mst.cost_mthd_code%TYPE;
2149: x_cost_component_class_id cm_cmpt_mst.cost_cmpntcls_id%TYPE;
2150: x_cost_analysis_code cm_alys_mst.cost_analysis_code%TYPE;
2151:
2152: BEGIN
2153: