DBA Data[Home] [Help]

APPS.POS_EXCELASN_PVT dependencies on AP_TERMS_VAL_V

Line 1560: (select 1 from ap_terms_val_v av

1556: select pht.line_number, pht.payment_terms
1557: from pos_exasn_headers pht
1558: where pht.payment_terms is not null
1559: and not exists
1560: (select 1 from ap_terms_val_v av
1561: where av.name = pht.payment_terms);
1562:
1563: --H9: Bad if expected receipt Date is BEFORE Shipment Date
1564: cursor l_checkER_Ship_csr

Line 3127: from ap_terms_val_v atv

3123: -- Update Payment Term ID, if any
3124: update pos_exasn_headers pht
3125: set payment_term_id =
3126: (select atv.term_id
3127: from ap_terms_val_v atv
3128: where atv.name = pht.payment_terms)
3129: where payment_terms is not null;
3130: -------------------
3131: