APPS.JA_JAINSTPR_XMLP_PKG dependencies on JAI_AR_SUP_LINES

Line 17: JAI_AR_SUP_LINES B,

13: SELECT
14: SUM(DIFF_AMT) EXCISE
15: FROM
16: JAI_AR_SUP_TAXES A,
17: JAI_AR_SUP_LINES B,
18: JAI_AR_SUP_HDRS_ALL C
19: WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
20: AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE
21: AND B.CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID

Line 52: JAI_AR_SUP_LINES B,

48: SELECT
49: SUM(DIFF_AMT) SALES
50: FROM
51: JAI_AR_SUP_TAXES A,
52: JAI_AR_SUP_LINES B,
53: JAI_AR_SUP_HDRS_ALL C
54: WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
55: AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE
56: AND B.CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID

Line 87: JAI_AR_SUP_LINES B,

83: SELECT
84: SUM(DIFF_AMT) EXCISE
85: FROM
86: JAI_AR_SUP_TAXES A,
87: JAI_AR_SUP_LINES B,
88: JAI_AR_SUP_HDRS_ALL C
89: WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
90: AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE
91: AND B.CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID

Line 125: JAI_AR_SUP_LINES B,

121: SELECT
122: SUM(DIFF_AMT) OTHER
123: FROM
124: JAI_AR_SUP_TAXES A,
125: JAI_AR_SUP_LINES B,
126: JAI_AR_SUP_HDRS_ALL C
127: WHERE C.CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID
128: AND C.SUPP_INV_TYPE = B.SUP_INV_TYPE
129: AND B.CUSTOMER_TRX_LINE_ID = A.LINK_TO_CUST_TRX_LINE_ID