APPS.ASO_QUOTE_PUB_W dependencies on ASO_QUOTE_LINE_DETAILS

Line 9993: from aso_quote_line_details

9989:
9990: l_debug VARCHAR2(1);
9991: CURSOR l_old_cfg_csr(p_c_quote_line_id NUMBER) IS
9992: select config_header_id, config_revision_num
9993: from aso_quote_line_details
9994: where quote_line_id = p_c_quote_line_id;
9995:
9996: BEGIN
9997: l_debug := ASO_QUOTE_UTIL_PVT.is_debug_enabled;

Line 14126: FROM ASO_QUOTE_LINE_DETAILS

14122: CURSOR C_Model_Config_Info (pc_quote_line_id IN NUMBER)
14123: IS
14124: SELECT config_header_id,
14125: config_revision_num
14126: FROM ASO_QUOTE_LINE_DETAILS
14127: WHERE quote_line_id = pc_quote_line_id
14128: ;
14129:
14130: /* declare a cursor to retrieve the rollup quote price of a model item */

Line 14138: ASO_QUOTE_LINE_DETAILS aqld

14134: SELECT SUM(DECODE(aql.line_category_code, 'RETURN', -1, 1) *
14135: NVL(aql.quantity, 0) *
14136: NVL(aql.line_quote_price, 0))
14137: FROM ASO_QUOTE_LINES_ALL aql,
14138: ASO_QUOTE_LINE_DETAILS aqld
14139: WHERE aql.quote_line_id = aqld.quote_line_id
14140: AND aqld.config_header_id = pc_config_header_id
14141: AND aqld.config_revision_num = pc_config_revision_number
14142: ;

Line 14144: l_config_header_id ASO_QUOTE_LINE_DETAILS.config_header_id%TYPE;

14140: AND aqld.config_header_id = pc_config_header_id
14141: AND aqld.config_revision_num = pc_config_revision_number
14142: ;
14143:
14144: l_config_header_id ASO_QUOTE_LINE_DETAILS.config_header_id%TYPE;
14145: l_config_revision_number ASO_QUOTE_LINE_DETAILS.config_revision_num%TYPE;
14146: x_rollup_quote_price NUMBER := 0;
14147: BEGIN
14148: OPEN C_Model_Config_Info(p_quote_line_id);

Line 14145: l_config_revision_number ASO_QUOTE_LINE_DETAILS.config_revision_num%TYPE;

14141: AND aqld.config_revision_num = pc_config_revision_number
14142: ;
14143:
14144: l_config_header_id ASO_QUOTE_LINE_DETAILS.config_header_id%TYPE;
14145: l_config_revision_number ASO_QUOTE_LINE_DETAILS.config_revision_num%TYPE;
14146: x_rollup_quote_price NUMBER := 0;
14147: BEGIN
14148: OPEN C_Model_Config_Info(p_quote_line_id);
14149: FETCH C_Model_Config_Info INTO l_config_header_id, l_config_revision_number;

Line 14426: FROM ASO_QUOTE_LINE_DETAILS

14422: IS
14423: CURSOR C_Node_Type (pc_quote_line_id IN NUMBER)
14424: IS
14425: SELECT (1)
14426: FROM ASO_QUOTE_LINE_DETAILS
14427: WHERE ref_type_code = 'CONFIG'
14428: AND ref_line_id = pc_quote_line_id
14429: AND ROWNUM = 1
14430: ;

Line 14446: FROM ASO_QUOTE_LINE_DETAILS

14442: IS
14443: CURSOR C_Depth (pc_quote_line_id IN NUMBER)
14444: IS
14445: SELECT NVL(LENGTH(TRANSLATE(component_code, '-0123456789', '-')), 0) depth
14446: FROM ASO_QUOTE_LINE_DETAILS
14447: WHERE quote_line_id = pc_quote_line_id
14448: ;
14449: x_depth NUMBER := 0;
14450: BEGIN