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,
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'