DBA Data[Home] [Help]

APPS.JA_JAINITCP_XMLP_PKG dependencies on JAI_AP_TDS_F16_HDRS_ALL

Line 46: JAI_AP_TDS_F16_HDRS_ALL AFRM,

42: SELECT
43: MIN(API2.INVOICE_DATE)
44: INTO P_FROM_DATE_T
45: FROM
46: JAI_AP_TDS_F16_HDRS_ALL AFRM,
47: JAI_AP_TDS_F16_DTLS_ALL FRMD,
48: HR_ORGANIZATION_UNITS HOU,
49: HR_LOCATIONS LOC,
50: JAI_CMN_INVENTORY_ORGS JHOU,

Line 151: JAI_AP_TDS_F16_HDRS_ALL AFRM,

147: ( NVL(PO.VENDOR_NAME
148: ,'NULL') )
149: FROM
150: PO_VENDORS PO,
151: JAI_AP_TDS_F16_HDRS_ALL AFRM,
152: JAI_AP_TDS_VENDOR_HDRS TDS
153: WHERE PO.VENDOR_ID = AFRM.TAX_AUTHORITY_ID
154: AND TDS.TAX_ID = AFRM.TDS_TAX_ID
155: AND AFRM.TDS_TAX_SECTION = P_TDS_PAYMENT_TYPE;