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 667: po_vendors ven,

663: FROM zx_rec_nrec_dist zl,
664: zx_rates_b tax,
665: ap_invoices inv,
666: ap_invoice_distributions dis,
667: po_vendors ven,
668: ap_invoice_distributions acctinfo
669: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
670: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)
671: 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 764: po_vendors ven,

760: FROM zx_rec_nrec_dist zl,
761: zx_rates_b tax,
762: ap_invoices inv,
763: ap_invoice_distributions dis,
764: po_vendors ven,
765: ap_invoice_distributions acctinfo
766: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
767: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)
768: 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 860: po_vendors ven,

856: FROM zx_rec_nrec_dist zl,
857: zx_rates_b tax,
858: ap_invoices inv,
859: ap_invoice_distributions dis,
860: po_vendors ven,
861: ap_invoice_payments aip,
862: ap_checks_all chk,
863: ap_invoice_distributions acctinfo
864: WHERE ((p_ledger_id IS NULL

Line 969: po_vendors ven,

965: FROM zx_rec_nrec_dist zl,
966: zx_rates_b tax,
967: ap_invoices inv,
968: ap_invoice_distributions dis,
969: po_vendors ven,
970: zx_rec_nrec_dist nrec,
971: ap_invoice_distributions acctinfo
972: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
973: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)

Line 1050: po_vendors ven,

1046: FROM zx_rec_nrec_dist zl,
1047: zx_rates_b tax,
1048: ap_invoices inv,
1049: ap_invoice_distributions dis,
1050: po_vendors ven,
1051: zx_rec_nrec_dist nrec,
1052: ap_invoice_distributions acctinfo
1053: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
1054: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)

Line 1146: po_vendors ven,

1142: FROM zx_rec_nrec_dist zl,
1143: zx_rates_b tax,
1144: ap_invoices inv,
1145: ap_invoice_distributions dis,
1146: po_vendors ven,
1147: ap_invoice_distributions pre,
1148: ap_invoice_distributions acctinfo
1149: WHERE ((p_ledger_id IS NULL
1150: AND p_company IS NULL