DBA Data[Home] [Help]

APPS.OKC_OC_INT_CONFIG_PVT dependencies on OKX_QTE_LINE_RLSHPS_V

Line 71: FROM OKX_QUOTE_LINES_V a,OKX_QTE_LINE_RLSHPS_V b,OKX_QUOTE_LINE_DETAIL_V c

67: ,c.valid_configuration_flag config_valid_yn
68: ,c.complete_configuration_flag config_complete_yn
69: ,a.line_number seq -- for sorting Bug 2087912
70: -- Changed refrence to ASO tables to OKX views
71: FROM OKX_QUOTE_LINES_V a,OKX_QTE_LINE_RLSHPS_V b,OKX_QUOTE_LINE_DETAIL_V c
72: WHERE b_q_flag = OKC_API.G_TRUE
73: AND a.id1 = b.related_quote_line_id
74: AND a.id1 = c.quote_line_id
75: AND b.quote_line_id= b_line_id

Line 1000: okx_qte_line_rlshps_v

996: SELECT
997: quote_line_id,
998: line_relationship_id
999: FROM
1000: okx_qte_line_rlshps_v
1001: -- aso_line_relationships
1002: WHERE
1003: related_quote_line_id = b_rlted_qle_id
1004: AND relationship_type_code = 'CONFIG';