DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS2 dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 515: 'PO_LINE_LOCATIONS_DRAFT_ALL',

511: token1_value,
512: validation_id)
513: SELECT x_result_set_id,
514: po_validations.c_result_type_failure,
515: 'PO_LINE_LOCATIONS_DRAFT_ALL',
516: p_id_tbl(i),
517: 'PO_PDOI_SHIPMENT_NUM_UNIQUE',
518: 'SHIPMENT_NUM',
519: p_shipment_num_tbl(i),

Line 536: FROM po_line_locations_draft_all

532: AND shipment_num = p_shipment_num_tbl(i)
533: AND p_doc_type = 'BLANKET' -- bug 4642348
534: AND shipment_type = 'PRICE BREAK') -- Bug#16501849
535: OR EXISTS(SELECT 1
536: FROM po_line_locations_draft_all
537: WHERE po_header_id = p_po_header_id_tbl(i)
538: AND po_line_id = p_po_line_id_tbl(i)
539: AND draft_id = p_draft_id_tbl(i) -- bug 4642348
540: AND shipment_num = p_shipment_num_tbl(i)

Line 1777: 'PO_LINE_LOCATIONS_DRAFT_ALL',

1773: token1_name,
1774: token1_value)
1775: SELECT x_result_set_id,
1776: po_validations.c_result_type_failure,
1777: 'PO_LINE_LOCATIONS_DRAFT_ALL',
1778: p_id_tbl(i),
1779: 'PO_PDOI_INVALID_ROUTING_ID',
1780: 'RECEIVING_ROUTING_ID',
1781: p_receiving_routing_id_tbl(i),