eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_LINES_SV11 dependencies on STANDARD

Line 197: AND shipment_type in ('STANDARD','PLANNED')

193: FROM po_line_locations
194: WHERE po_line_id = X_po_line_id
195: AND nvl(cancel_flag,'N') = 'N'
196: AND unit_meas_lookup_code <> X_unit_meas_lookup_code
197: AND shipment_type in ('STANDARD','PLANNED')
198: AND secondary_unit_of_measure is NOT NULL;
199:
200: l_shipment_quantity number;
201: l_shipment_sec_quantity number;

Line 209: if ( (p_type_lookup_code = 'STANDARD') OR

205: BEGIN
206:
207: X_progress := '010';
208:
209: if ( (p_type_lookup_code = 'STANDARD') OR
210: (p_type_lookup_code = 'PLANNED' ) OR
211: (p_type_lookup_code = 'BLANKET' )) then
212:
213: /* Check if the document has to be unapproved */

Line 269: if ( (p_type_lookup_code = 'STANDARD') OR

265:
266: end if; /* end of testing x_approved_flag */
267:
268:
269: if ( (p_type_lookup_code = 'STANDARD') OR
270: (p_type_lookup_code = 'PLANNED' ) ) then
271:
272: /* If the Unit Price on the line has changed, update every shipment of SHIPMENT/PLANNED
273: ** shipment type and that is not cancelled, with this price.

Line 292: AND shipment_type in ('STANDARD','PLANNED') ;

288: last_update_date = sysdate,
289: last_updated_by = X_last_updated_by,
290: last_update_login = X_last_update_login
291: WHERE po_line_id = X_po_line_id
292: AND shipment_type in ('STANDARD','PLANNED') ;
293:
294:
295: -- set document status to be requires reapproval
296: if X_approved_flag IN ( 'Y', 'X') then

Line 377: AND shipment_type in ('STANDARD','PLANNED') ;

373: last_update_login = X_last_update_login
374: WHERE po_line_id = X_po_line_id
375: AND nvl(cancel_flag,'N') = 'N'
376: AND unit_meas_lookup_code <> X_unit_meas_lookup_code
377: AND shipment_type in ('STANDARD','PLANNED') ;
378:
379:
380: /* If there is only one shipment for this location, and the quantity is changed,
381: ** update the shipment. SImilarly, if there is only one distribution, we need to

Line 405: AND pll2.shipment_type IN ('STANDARD','PLANNED')

401: WHERE pll.po_line_id = X_po_line_id
402: AND NOT EXISTS (SELECT 'there are encumbered or cancelled or drop shipments'
403: FROM po_line_locations pll2
404: WHERE pll2.po_line_id = X_po_line_id
405: AND pll2.shipment_type IN ('STANDARD','PLANNED')
406: AND ( nvl(pll2.encumbered_flag, 'N') <> 'N'
407: OR nvl(pll2.cancel_flag,'N') <> 'N'
408: OR nvl(pll2.closed_code,'OPEN') = 'FINALLY CLOSED' --bug 5856760
409: OR nvl(pll2.drop_ship_flag,'N') <> 'N') --bug 3359011

Line 429: AND pll.shipment_type IN ('STANDARD','PLANNED')

425: INTO X_secondary_quantity_ship,
426: X_ship_org_id
427: FROM po_line_locations pll
428: WHERE pll.po_line_id = X_po_line_id
429: AND pll.shipment_type IN ('STANDARD','PLANNED')
430: AND nvl(pll.cancel_flag,'N') <> 'Y';
431:
432: IF X_secondary_quantity_ship IS NOT NULL THEN
433:

Line 496: AND shipment_type = 'STANDARD';

492: -- shipment are being updated
493: tax_attribute_update_code = nvl(tax_attribute_update_code, 'UPDATE')
494: WHERE po_line_id = X_po_line_id
495: AND nvl(cancel_flag,'N') <> 'Y'
496: AND shipment_type = 'STANDARD';
497:
498: END IF;
499:
500: ELSE

Line 527: AND shipment_type IN ('STANDARD','PLANNED');

523: -- shipment are being updated
524: tax_attribute_update_code = nvl(tax_attribute_update_code, 'UPDATE')
525: WHERE po_line_id = X_po_line_id
526: AND nvl(cancel_flag,'N') <> 'Y'
527: AND shipment_type IN ('STANDARD','PLANNED');
528:
529: END IF;
530:
531: END IF;

Line 594: AND pll.shipment_type IN ('STANDARD','PLANNED');

590: X_days_late_receipt_allowed
591: FROM po_line_locations pll
592: WHERE pll.po_line_id = X_po_line_id
593: AND nvl(pll.cancel_flag,'N') <> 'Y'
594: AND pll.shipment_type IN ('STANDARD','PLANNED');
595:
596:
597: if X_num_of_shipments = 1 then
598:

Line 604: IF p_type_lookup_code IN ('STANDARD',

600: --START Bug 5533266
601: /*This is to enforce the user to enter either a promise by date or need by date before updating the record.
602: The previous related bugs had the fix at the W-V-R for the PO_LINES block and the same are reverted as a part of this fix */
603:
604: IF p_type_lookup_code IN ('STANDARD',
605: 'PLANNED') THEN
606: IF p_planned_item_flag = 'Y'
607: AND p_promised_date IS NULL
608: AND p_need_by_date IS NULL THEN

Line 631: AND shipment_type IN ('STANDARD','PLANNED');

627: -- shipment are being updated
628: tax_attribute_update_code = nvl(tax_attribute_update_code, 'UPDATE')
629: WHERE po_line_id = X_po_line_id
630: AND nvl(cancel_flag,'N') <> 'Y'
631: AND shipment_type IN ('STANDARD','PLANNED');
632:
633: -- set document status to be requires reapproval
634: if X_approved_flag IN ('Y','X') then
635: X_approved_flag := 'Z';

Line 643: end if; /* End of If Standard/Planned */

639:
640: end if; /* Change Promised and need by dates at shipment level */
641:
642:
643: end if; /* End of If Standard/Planned */
644: end if; /* End of If Standard/Planned/Blanket */
645:
646: -- Bug 7577670: Derive ip_category_id from po_category_id
647: PO_ATTRIBUTE_VALUES_PVT.get_ip_category_id(p_po_category_id => x_category_id,

Line 644: end if; /* End of If Standard/Planned/Blanket */

640: end if; /* Change Promised and need by dates at shipment level */
641:
642:
643: end if; /* End of If Standard/Planned */
644: end if; /* End of If Standard/Planned/Blanket */
645:
646: -- Bug 7577670: Derive ip_category_id from po_category_id
647: PO_ATTRIBUTE_VALUES_PVT.get_ip_category_id(p_po_category_id => x_category_id,
648: x_ip_category_id => l_ip_category_id);