APPS.JA_JAINCTRB_XMLP_PKG dependencies on PO_VENDORS

Line 4: V_VENDOR_TYPE_LOOKUP_CODE PO_VENDORS.VENDOR_TYPE_LOOKUP_CODE%TYPE;

1: PACKAGE BODY JA_JAINCTRB_XMLP_PKG AS
2: /* $Header: JAINCTRBB.pls 120.1 2007/12/25 16:15:35 dwkrishn noship $ */
3: FUNCTION CF_VENDOR_TYPEFORMULA(VENDOR_ID IN NUMBER) RETURN VARCHAR2 IS
4: V_VENDOR_TYPE_LOOKUP_CODE PO_VENDORS.VENDOR_TYPE_LOOKUP_CODE%TYPE;
5: BEGIN
6: SELECT
7: VENDOR_TYPE_LOOKUP_CODE
8: INTO V_VENDOR_TYPE_LOOKUP_CODE

Line 10: PO_VENDORS

6: SELECT
7: VENDOR_TYPE_LOOKUP_CODE
8: INTO V_VENDOR_TYPE_LOOKUP_CODE
9: FROM
10: PO_VENDORS
11: WHERE VENDOR_ID = cf_vendor_typeformula.VENDOR_ID;
12: RETURN (V_VENDOR_TYPE_LOOKUP_CODE);
13: END CF_VENDOR_TYPEFORMULA;
14:

Line 22: PO_VENDORS

18: SELECT
19: VENDOR_NAME
20: INTO V_VENDOR_NAME
21: FROM
22: PO_VENDORS
23: WHERE VENDOR_ID = cf_vendor_nameformula.VENDOR_ID;
24: RETURN (V_VENDOR_NAME);
25: END CF_VENDOR_NAMEFORMULA;
26:

Line 34: PO_VENDORS

30: SELECT
31: SEGMENT1
32: INTO V_VENDOR_CODE
33: FROM
34: PO_VENDORS
35: WHERE VENDOR_ID = cf_vendor_codeformula.VENDOR_ID;
36: RETURN (V_VENDOR_CODE);
37: END CF_VENDOR_CODEFORMULA;
38:

Line 77: PO_VENDORS POV,

73: INTO V_AMOUNT_CR1
74: FROM
75: AP_INVOICES_ALL A,
76: AP_INVOICE_DISTRIBUTIONS_ALL B,
77: PO_VENDORS POV,
78: PO_VENDOR_SITES_ALL POVS
79: WHERE A.INVOICE_ID = B.INVOICE_ID
80: AND POV.VENDOR_ID = A.VENDOR_ID
81: AND POV.VENDOR_ID = POVS.VENDOR_ID

Line 101: PO_VENDORS POV,

97: INTO V_AMOUNT_CR2
98: FROM
99: AP_INVOICES_ALL A,
100: AP_INVOICE_DISTRIBUTIONS_ALL B,
101: PO_VENDORS POV,
102: PO_VENDOR_SITES_ALL POVS
103: WHERE A.INVOICE_ID = B.INVOICE_ID
104: AND POV.VENDOR_ID = A.VENDOR_ID
105: AND POV.VENDOR_ID = POVS.VENDOR_ID

Line 126: PO_VENDORS POV,

122: FROM
123: AP_INVOICES_ALL A,
124: AP_INVOICE_PAYMENTS_ALL B,
125: AP_CHECKS_ALL C,
126: PO_VENDORS POV,
127: PO_VENDOR_SITES_ALL POVS
128: WHERE A.INVOICE_ID = B.INVOICE_ID
129: AND POV.VENDOR_ID = A.VENDOR_ID
130: AND B.CHECK_ID = C.CHECK_ID

Line 149: PO_VENDORS POV,

145: INTO V_AMOUNT_DR2
146: FROM
147: AP_INVOICES_ALL A,
148: AP_INVOICE_DISTRIBUTIONS_ALL B,
149: PO_VENDORS POV,
150: PO_VENDOR_SITES_ALL POVS
151: WHERE A.INVOICE_ID = B.INVOICE_ID
152: AND POV.VENDOR_ID = A.VENDOR_ID
153: AND POV.VENDOR_ID = POVS.VENDOR_ID

Line 199: PO_VENDORS POV,

195: MIN(B.EXCHANGE_RATE) EXCHANGE_RATE
196: FROM
197: AP_INVOICES_ALL A,
198: AP_INVOICE_DISTRIBUTIONS_ALL B,
199: PO_VENDORS POV,
200: PO_VENDOR_SITES_ALL POVS
201: WHERE A.INVOICE_ID = B.INVOICE_ID
202: AND POV.VENDOR_ID = A.VENDOR_ID
203: AND POVS.VENDOR_ID = POV.VENDOR_ID

Line 230: PO_VENDORS POV,

226: FROM
227: AP_INVOICES_ALL A,
228: AP_INVOICE_PAYMENTS_ALL B,
229: AP_CHECKS_ALL C,
230: PO_VENDORS POV,
231: PO_VENDOR_SITES_ALL POVS
232: WHERE A.INVOICE_ID = B.INVOICE_ID
233: AND POV.VENDOR_ID = A.VENDOR_ID
234: AND B.CHECK_ID = C.CHECK_ID

Line 257: PO_VENDORS POV,

253: A.INVOICE_CURRENCY_CODE
254: FROM
255: AP_INVOICES_ALL A,
256: AP_INVOICE_DISTRIBUTIONS_ALL B,
257: PO_VENDORS POV,
258: PO_VENDOR_SITES_ALL POVS
259: WHERE A.INVOICE_ID = B.INVOICE_ID
260: AND POV.VENDOR_ID = A.VENDOR_ID
261: AND POVS.VENDOR_ID = POV.VENDOR_ID

Line 284: PO_VENDORS POV,

280: MIN(A.EXCHANGE_DATE) EXCHANGE_DATE
281: FROM
282: AP_INVOICES_ALL B,
283: AP_INVOICE_DISTRIBUTIONS_ALL A,
284: PO_VENDORS POV,
285: PO_VENDOR_SITES_ALL POVS
286: WHERE A.INVOICE_ID = B.INVOICE_ID
287: AND POV.VENDOR_ID = B.VENDOR_ID
288: AND B.VENDOR_ID = NVL(P_VENDOR_ID

Line 377: PO_VENDORS POV,

373: INTO V_SUM_EXCH_GAIN_AMT,V_SUM_EXCH_LOSS_AMT
374: FROM
375: AP_INVOICES_ALL A,
376: AP_INVOICE_DISTRIBUTIONS_ALL B,
377: PO_VENDORS POV,
378: PO_VENDOR_SITES_ALL POVS,
379: XLA_AE_LINES XAL,
380: XLA_AE_HEADERS XAH,
381: XLA_TRANSACTION_ENTITIES XTE

Line 494: PO_VENDORS

490: CURSOR FOR_VENDOR_NAME(V_ID IN NUMBER) IS
491: SELECT
492: VENDOR_NAME
493: FROM
494: PO_VENDORS
495: WHERE VENDOR_ID = V_ID;
496: V_VENDOR_NAME VARCHAR(100);
497: BEGIN
498: OPEN FOR_VENDOR_NAME(P_VENDOR_ID);