DBA Data[Home] [Help]

APPS.POS_EXCELASN_PVT dependencies on AP_TERMS_VAL_V

Line 1490: (select 1 from ap_terms_val_v av

1486: select pht.line_number, pht.payment_terms
1487: from pos_exasn_headers pht
1488: where pht.payment_terms is not null
1489: and not exists
1490: (select 1 from ap_terms_val_v av
1491: where av.name = pht.payment_terms);
1492:
1493: --H9: Bad if expected receipt Date is BEFORE Shipment Date
1494: cursor l_checkER_Ship_csr

Line 3057: from ap_terms_val_v atv

3053: -- Update Payment Term ID, if any
3054: update pos_exasn_headers pht
3055: set payment_term_id =
3056: (select atv.term_id
3057: from ap_terms_val_v atv
3058: where atv.name = pht.payment_terms)
3059: where payment_terms is not null;
3060: -------------------
3061: