APPS.ASO_BI_APPR_FACT_PVT dependencies on ASO_APR_OBJ_APPROVALS

Line 62: ASO_APR_OBJ_APPROVALS APR,

58: SYSDATE,
59: l_user_id,
60: l_login_id
61: FROM ASO_BI_QUOTE_HDRS_ALL QOT,
62: ASO_APR_OBJ_APPROVALS APR,
63: ASO_APR_APPROVAL_DETAILS APRD
64: WHERE
65: QOT.quote_header_id = APR.object_id
66: AND APR.object_type = 'Quote'

Line 70: from ASO_APR_OBJ_APPROVALS A

66: AND APR.object_type = 'Quote'
67: AND APRD.object_approval_id = APR.object_approval_id
68: AND QOT.recurring_charge_flag = 'N'
69: AND APR.approval_instance_id = (select max(approval_instance_id)
70: from ASO_APR_OBJ_APPROVALS A
71: where A.Object_id = QOT.Quote_header_id)
72: GROUP BY
73: QOT.Quote_Number, QOT.Quote_Version,
74: QOT.Quote_creation_date,QOT.Quote_last_update_date,

Line 150: ASO_APR_OBJ_APPROVALS APR,

146: SYSDATE,
147: l_user_id,
148: l_login_id
149: FROM ASO_BI_QUOTE_HDRS_ALL QOT,
150: ASO_APR_OBJ_APPROVALS APR,
151: ASO_APR_APPROVAL_DETAILS APRD,
152: ASO_BI_QUOTE_IDS QID
153: WHERE
154: QOT.quote_header_id = APR.object_id

Line 160: from ASO_APR_OBJ_APPROVALS A

156: AND QID.quote_header_id = APR.object_id
157: AND APRD.object_approval_id = APR.object_approval_id
158: AND QOT.recurring_charge_flag = 'N'
159: AND APR.approval_instance_id = (select max(approval_instance_id)
160: from ASO_APR_OBJ_APPROVALS A
161: where A.Object_id = QOT.Quote_header_id)
162: GROUP BY
163: QOT.Quote_Number, QOT.Quote_Version,
164: QOT.Quote_creation_date,QOT.Quote_last_update_date,