APPS.ASO_COPY_TMPL_PUB dependencies on ASO_LINE_RELATIONSHIPS

Line 448: FROM ASO_LINE_RELATIONSHIPS

444: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
445: , REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID
446: , PROGRAM_UPDATE_DATE, QUOTE_LINE_ID, RELATED_QUOTE_LINE_ID
447: , RELATIONSHIP_TYPE_CODE, RECIPROCAL_FLAG, OBJECT_VERSION_NUMBER
448: FROM ASO_LINE_RELATIONSHIPS
449: WHERE quote_line_id IN ( SELECT quote_line_id
450: FROM aso_quote_lines_all
451: WHERE quote_header_id = x_quote_header_id )
452: AND relationship_type_code <> 'SERVICE';

Line 543: FROM ASO_LINE_RELATIONSHIPS

539: , LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
540: , REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID
541: , PROGRAM_UPDATE_DATE, QUOTE_LINE_ID, RELATED_QUOTE_LINE_ID
542: , RELATIONSHIP_TYPE_CODE, RECIPROCAL_FLAG, OBJECT_VERSION_NUMBER
543: FROM ASO_LINE_RELATIONSHIPS
544: WHERE relationship_type_code <> 'SERVICE'
545: CONNECT BY PRIOR related_quote_line_id = quote_line_id
546: START WITH quote_line_id = x_quote_line_id;
547:

Line 1121: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (

1117: -- copy line relationships
1118:
1119: FOR line_rel_rec IN c_line_relation ( p_qte_header_id ) LOOP
1120: lx_LINE_RELATIONSHIP_ID := FND_API.G_MISS_NUM;
1121: ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (
1122: px_LINE_RELATIONSHIP_ID => lx_LINE_RELATIONSHIP_ID
1123: , p_CREATION_DATE => SYSDATE
1124: , p_CREATED_BY => G_USER_ID
1125: , p_LAST_UPDATED_BY => G_USER_ID

Line 1221: FROM aso_line_relationships

1217: CURSOR line_id_from_service (
1218: qte_ln_id NUMBER
1219: ) IS
1220: SELECT related_quote_line_id
1221: FROM aso_line_relationships
1222: WHERE quote_line_id = qte_ln_id
1223: AND relationship_type_code = 'SERVICE';
1224:
1225: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;