DBA Data[Home] [Help]

APPS.PN_EXP_TO_AP dependencies on PN_LEASE_DETAILS_ALL

Line 75: pn_lease_details_all pld,

71: FROM pn_payment_items pi,
72: pn_payment_schedules_all ps,
73: pn_payment_terms_all pt,
74: pn_leases_all le,
75: pn_lease_details_all pld,
76: fnd_lookups type_lookup,
77: fnd_lookups purpose_lookup,
78: po_vendors vendor,
79: hr_operating_units ou,

Line 2168: pn_lease_details_all pld

2164: SELECT pld.grouping_rule_id
2165: FROM pn_payment_items pi,
2166: pn_payment_terms_all pt,
2167: pn_leases_all le,
2168: pn_lease_details_all pld
2169: WHERE pi.payment_term_id = pt.payment_term_id
2170: AND pt.lease_id = le.lease_id
2171: AND pld.lease_id = le.lease_id
2172: AND nvl(pi.export_to_ap_flag,'N') = 'Y'