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 224: if ( (p_type_lookup_code = 'STANDARD') OR

220: from po_lines_all
221: where po_line_id = X_po_line_id;
222:
223:
224: if ( (p_type_lookup_code = 'STANDARD') OR
225: (p_type_lookup_code = 'PLANNED' ) OR
226: (p_type_lookup_code = 'BLANKET' )) then
227:
228: /* Check if the document has to be unapproved */

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

280:
281: end if; /* end of testing x_approved_flag */
282:
283:
284: if ( (p_type_lookup_code = 'STANDARD') OR
285: (p_type_lookup_code = 'PLANNED' ) ) then
286:
287: /* If the Unit Price on the line has changed, update every shipment of SHIPMENT/PLANNED
288: ** shipment type and that is not cancelled, with this price.

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

303: last_update_date = sysdate,
304: last_updated_by = X_last_updated_by,
305: last_update_login = X_last_update_login
306: WHERE po_line_id = X_po_line_id
307: AND shipment_type in ('STANDARD','PLANNED') ;
308:
309:
310: -- set document status to be requires reapproval
311: if X_approved_flag IN ( 'Y', 'X') then

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

388: last_update_login = X_last_update_login
389: WHERE po_line_id = X_po_line_id
390: AND nvl(cancel_flag,'N') = 'N'
391: AND unit_meas_lookup_code <> X_unit_meas_lookup_code
392: AND shipment_type in ('STANDARD','PLANNED') ;
393:
394:
395: /* If there is only one shipment for this location, and the quantity is changed,
396: ** update the shipment. SImilarly, if there is only one distribution, we need to

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

418: WHERE pll.po_line_id = X_po_line_id
419: AND NOT EXISTS (SELECT 'there are encumbered or cancelled or drop shipments'
420: FROM po_line_locations pll2
421: WHERE pll2.po_line_id = X_po_line_id
422: AND pll2.shipment_type IN ('STANDARD','PLANNED')
423: AND ( nvl(pll2.encumbered_flag, 'N') <> 'N'
424: OR nvl(pll2.cancel_flag,'N') <> 'N'
425: OR nvl(pll2.closed_code,'OPEN') = 'FINALLY CLOSED' --bug 5856760
426: OR nvl(pll2.drop_ship_flag,'N') <> 'N') --bug 3359011

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

442: INTO X_secondary_quantity_ship,
443: X_ship_org_id
444: FROM po_line_locations pll
445: WHERE pll.po_line_id = X_po_line_id
446: AND pll.shipment_type IN ('STANDARD','PLANNED')
447: AND nvl(pll.cancel_flag,'N') <> 'Y';
448:
449: IF X_secondary_quantity_ship IS NOT NULL THEN
450:

Line 513: AND shipment_type = 'STANDARD';

509: -- shipment are being updated
510: tax_attribute_update_code = nvl(tax_attribute_update_code, 'UPDATE')
511: WHERE po_line_id = X_po_line_id
512: AND nvl(cancel_flag,'N') <> 'Y'
513: AND shipment_type = 'STANDARD';
514:
515: END IF;
516:
517: ELSE

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

540: -- shipment are being updated
541: tax_attribute_update_code = nvl(tax_attribute_update_code, 'UPDATE')
542: WHERE po_line_id = X_po_line_id
543: AND nvl(cancel_flag,'N') <> 'Y'
544: AND shipment_type IN ('STANDARD','PLANNED');
545:
546: END IF;
547:
548: END IF;

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

607: X_days_late_receipt_allowed
608: FROM po_line_locations pll
609: WHERE pll.po_line_id = X_po_line_id
610: AND nvl(pll.cancel_flag,'N') <> 'Y'
611: AND pll.shipment_type IN ('STANDARD','PLANNED');
612:
613:
614: if X_num_of_shipments = 1 then
615:

Line 621: IF p_type_lookup_code IN ('STANDARD',

617: --START Bug 5533266
618: /*This is to enforce the user to enter either a promise by date or need by date before updating the record.
619: 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 */
620:
621: IF p_type_lookup_code IN ('STANDARD',
622: 'PLANNED') THEN
623: IF p_planned_item_flag = 'Y'
624: AND p_promised_date IS NULL
625: AND p_need_by_date IS NULL THEN

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

644: -- shipment are being updated
645: tax_attribute_update_code = nvl(tax_attribute_update_code, 'UPDATE')
646: WHERE po_line_id = X_po_line_id
647: AND nvl(cancel_flag,'N') <> 'Y'
648: AND shipment_type IN ('STANDARD','PLANNED');
649:
650: -- set document status to be requires reapproval
651: if X_approved_flag IN ('Y','X') then
652: X_approved_flag := 'Z';

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

656:
657: end if; /* Change Promised and need by dates at shipment level */
658:
659:
660: end if; /* End of If Standard/Planned */
661: end if; /* End of If Standard/Planned/Blanket */
662:
663: ---13067295, Added the if condition to check whether the category_id has changed or not.
664: ---We will retrive the ip_category_id only when the po_category_id is changed.

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

657: end if; /* Change Promised and need by dates at shipment level */
658:
659:
660: end if; /* End of If Standard/Planned */
661: end if; /* End of If Standard/Planned/Blanket */
662:
663: ---13067295, Added the if condition to check whether the category_id has changed or not.
664: ---We will retrive the ip_category_id only when the po_category_id is changed.
665: