DBA Data[Home] [Help]

APPS.PN_EXP_TO_AP dependencies on PN_PAYMENT_ITEMS_NUM_S

Line 1261: ,'PN-'||PN_PAYMENT_ITEMS_NUM_S.nextval)

1257: ,exchange_date)
1258: VALUES
1259: (AP_INVOICES_INTERFACE_S.nextval
1260: ,NVL(l_invoice_num
1261: ,'PN-'||PN_PAYMENT_ITEMS_NUM_S.nextval)
1262: ,ROUND(l_header_amount,l_precision)
1263: ,exp_ap_cache(l_start).pn_export_currency_code
1264: ,'Lease Number: ' || exp_ap_cache(l_start).pn_lease_num
1265: ,'Oracle Property Manager'

Line 1809: ,'PN-'||PN_PAYMENT_ITEMS_NUM_S.nextval

1805: ,exchange_rate_type
1806: ,exchange_date)
1807: VALUES
1808: (AP_INVOICES_INTERFACE_S.nextval
1809: ,'PN-'||PN_PAYMENT_ITEMS_NUM_S.nextval
1810: ,ROUND(exp_ap_cache(item).pn_export_currency_amount,l_precision)
1811: ,exp_ap_cache(item).pn_export_currency_code
1812: ,'Lease Number: ' || exp_ap_cache(item).pn_lease_num
1813: ,'Oracle Property Manager'