[Home] [Help]
276:
277: --Conversion of req UOM to Quotation UOM should always happen if the
278: -- source document is a quote and profile 'PO: Convert Requisition UOM to Source Document UOM'
279: -- should be ignored in that case
280: IF (p_lines.from_line_id_tbl(i) IS NOT NULL) AND (PO_AUTOCREATE_PARAMS.g_document_subtype = 'STANDARD') THEN
281: l_progress := '120';
282:
283: BEGIN
284: --need to check ant interface.from_line_id and intreface.from_header_id
306:
307: END IF;
308:
309: IF (NVL(x_uom_convert,'N') = 'Y' OR (l_from_type_lookup_code = 'QUOTATION')) THEN
310: IF (PO_AUTOCREATE_PARAMS.g_document_subtype='STANDARD') AND (p_lines.from_line_id_tbl(i) IS NOT NULL) THEN
311: /* get the uom from the PO . This will be used for uom conversion */
312:
313: BEGIN
314: -- Autocreating a PO that references a GA
1441: AND deliv.line_location_id =
1442: (SELECT poll.line_location_id
1443: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll
1444: WHERE poll.po_line_id = p_lines.po_line_id_tbl(i)
1445: AND poll.shipment_type = 'STANDARD'
1446: AND poll.shipment_num =
1447: (SELECT MIN(poll2.shipment_num)
1448: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll2
1449: WHERE poll2.po_line_id = poll.po_line_id
1446: AND poll.shipment_num =
1447: (SELECT MIN(poll2.shipment_num)
1448: FROM PO_LINE_LOCATIONS_DRAFT_ALL poll2
1449: WHERE poll2.po_line_id = poll.po_line_id
1450: AND poll2.shipment_type = 'STANDARD'
1451: )
1452: )
1453: AND pod.line_location_id = deliv.line_location_id;
1454: