APPS.JE_ZZ_AUDIT_AP_PKG dependencies on PO_VENDORS

Line 118: FROM po_vendors ven

114: ,zl.application_id
115: ,zl.event_class_code
116: ,zl.trx_line_id
117: ,zl.entity_code
118: FROM po_vendors ven
119: ,ap_invoices inv
120: ,ap_invoice_distributions dis
121: ,zx_rates_b tax
122: ,ap_invoice_distributions item

Line 673: po_vendors ven,

669: FROM zx_rec_nrec_dist zl,
670: zx_rates_b tax,
671: ap_invoices inv,
672: ap_invoice_distributions dis,
673: po_vendors ven,
674: ap_invoice_distributions acctinfo
675: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
676: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)
677: OR (P_COMPANY IS NOT NULL AND inv.set_of_books_id = P_LEDGER_ID AND get_balancing_segment(dis.dist_code_combination_id) = P_COMPANY))

Line 788: po_vendors ven,

784: FROM zx_rec_nrec_dist zl,
785: zx_rates_b tax,
786: ap_invoices inv,
787: ap_invoice_distributions dis,
788: po_vendors ven,
789: ap_invoice_distributions acctinfo
790: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
791: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)
792: OR (P_COMPANY IS NOT NULL AND inv.set_of_books_id = P_LEDGER_ID AND get_balancing_segment(dis.dist_code_combination_id) = P_COMPANY))

Line 892: po_vendors ven,

888: 'JEFRTXDC'
889: FROM zx_rates_b tax,
890: ap_invoices inv,
891: ap_invoice_distributions dis,
892: po_vendors ven,
893: ap_invoice_payments aip,
894: ap_checks_all chk,
895: ap_invoice_distributions acctinfo,
896: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS

Line 1025: po_vendors ven,

1021: 'JEFRTXDC'
1022: FROM zx_rates_b tax,
1023: ap_invoices inv,
1024: ap_invoice_distributions dis,
1025: po_vendors ven,
1026: zx_rec_nrec_dist nrec,
1027: ap_invoice_distributions acctinfo,
1028: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS
1029: ON (accounts.TAX_ACCOUNT_ENTITY_ID =

Line 1123: po_vendors ven,

1119: 'JEFRTXDC'
1120: FROM zx_rates_b tax,
1121: ap_invoices inv,
1122: ap_invoice_distributions dis,
1123: po_vendors ven,
1124: zx_rec_nrec_dist nrec,
1125: ap_invoice_distributions acctinfo,
1126: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS
1127: ON (accounts.TAX_ACCOUNT_ENTITY_ID =

Line 1233: po_vendors ven,

1229: 'JEFRTXDC'
1230: FROM zx_rates_b tax,
1231: ap_invoices inv,
1232: ap_invoice_distributions dis,
1233: po_vendors ven,
1234: ap_invoice_distributions pre,
1235: ap_invoice_distributions acctinfo,
1236: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS
1237: ON (accounts.TAX_ACCOUNT_ENTITY_ID =