APPS.ASO_QUOTE_PUB_W dependencies on ASO_QUOTE_LINES_ALL

Line 14137: FROM ASO_QUOTE_LINES_ALL aql,

14133: IS
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

Line 14292: FROM ASO_QUOTE_LINES_ALL aql,

14288: SELECT atd.tax_code tax_code,
14289: atd.tax_inclusive_flag tax_inclusive_flag,
14290: SUM(NVL(atd.tax_amount, 0) *
14291: DECODE(aql.line_category_code, 'RETURN', -1, 1)) tax_amount
14292: FROM ASO_QUOTE_LINES_ALL aql,
14293: ASO_TAX_DETAILS atd
14294: WHERE aql.quote_line_id = atd.quote_line_id
14295: AND aql.quote_header_id = p_quote_header_id
14296: GROUP BY

Line 14464: FROM ASO_QUOTE_LINES_ALL

14460: IS
14461: CURSOR C_Component_Item (pc_quote_line_id IN NUMBER)
14462: IS
14463: SELECT item_type_code
14464: FROM ASO_QUOTE_LINES_ALL
14465: WHERE quote_line_id = pc_quote_line_id
14466: ;
14467: l_item_type_code VARCHAR2(10) := NULL;
14468: BEGIN