DBA Data[Home] [Help]

APPS.PO_VALIDATIONS dependencies on PO_LINES_ALL

Line 3807: -- validate unit_meas_lookup_code against po_lines_all and po_units_of_measure_val_v

3803: p_unit_price_tbl => p_lines.unit_price,
3804: x_results => x_results,
3805: x_result_type => l_result_type);
3806: WHEN c_uom_update THEN
3807: -- validate unit_meas_lookup_code against po_lines_all and po_units_of_measure_val_v
3808: -- for the Update case
3809: PO_VAL_LINES2.uom_update(p_id_tbl => p_lines.interface_id,
3810: p_unit_meas_lookup_code_tbl => p_lines.unit_meas_lookup_code,
3811: p_order_type_lookup_code_tbl => p_lines.order_type_lookup_code,

Line 7016: FROM po_lines_all pl,

7012:
7013: SELECT 'N','PO_INVALID_ENC_AMT' INTO x_return_status,x_return_message from dual
7014: WHERE EXISTS
7015: (SELECT po_distribution_id
7016: FROM po_lines_all pl,
7017: po_line_locations_all pll,
7018: po_distributions_all pod
7019: WHERE pod.line_location_id = pll.line_location_id
7020: AND pll.po_line_id = pl.po_line_id