DBA Data[Home] [Help]

APPS.PO_TAX_SUMMARY_PKG dependencies on STANDARD

Line 451: --Function: For Standard and Planned PO, it returns the amount of

447: --Pre-reqs:
448: --Modifies:
449: --Locks:
450: -- None
451: --Function: For Standard and Planned PO, it returns the amount of
452: -- a PO line; for local blanket, it returns the amount released
453: -- of the blanket line.
454: --Parameters:
455: --IN:

Line 507: AND PLL.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET');

503: FROM po_line_locations PLL,
504: po_lines POL
505: WHERE PLL.po_line_id = POL.po_line_id
506: AND POL.po_line_id = p_line_id
507: AND PLL.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET');
508:
509: ELSE
510:
511: --SQL WHAT: Calculate amount released for a PO/Blanket line.

Line 534: AND PLL.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET');

530: FROM po_line_locations PLL,
531: po_lines POL
532: WHERE PLL.po_line_id = POL.po_line_id
533: AND POL.po_line_id = p_line_id
534: AND PLL.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET');
535:
536: END IF;
537:
538: RETURN l_line_amount;