DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS2 dependencies on PO_LINE_LOCATIONS_DRAFT_ALL

Line 282: 'PO_LINE_LOCATIONS_DRAFT_ALL',

278: token1_value,
279: validation_id)
280: SELECT x_result_set_id,
281: po_validations.c_result_type_failure,
282: 'PO_LINE_LOCATIONS_DRAFT_ALL',
283: p_id_tbl(i),
284: 'PO_PDOI_SHIPMENT_NUM_UNIQUE',
285: 'SHIPMENT_NUM',
286: p_shipment_num_tbl(i),

Line 302: FROM po_line_locations_draft_all

298: AND po_line_id = p_po_line_id_tbl(i)
299: AND shipment_num = p_shipment_num_tbl(i)
300: AND p_doc_type = 'BLANKET') -- bug 4642348
301: OR EXISTS(SELECT 1
302: FROM po_line_locations_draft_all
303: WHERE po_header_id = p_po_header_id_tbl(i)
304: AND po_line_id = p_po_line_id_tbl(i)
305: AND draft_id = p_draft_id_tbl(i) -- bug 4642348
306: AND shipment_num = p_shipment_num_tbl(i)

Line 1413: 'PO_LINE_LOCATIONS_DRAFT_ALL',

1409: token1_name,
1410: token1_value)
1411: SELECT x_result_set_id,
1412: po_validations.c_result_type_failure,
1413: 'PO_LINE_LOCATIONS_DRAFT_ALL',
1414: p_id_tbl(i),
1415: 'PO_PDOI_INVALID_ROUTING_ID',
1416: 'RECEIVING_ROUTING_ID',
1417: p_receiving_routing_id_tbl(i),