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 2152: pn_lease_details_all pld

2148: SELECT pld.grouping_rule_id
2149: FROM pn_payment_items pi,
2150: pn_payment_terms_all pt,
2151: pn_leases_all le,
2152: pn_lease_details_all pld
2153: WHERE pi.payment_term_id = pt.payment_term_id
2154: AND pt.lease_id = le.lease_id
2155: AND pld.lease_id = le.lease_id
2156: AND nvl(pi.export_to_ap_flag,'N') = 'Y'