DBA Data[Home] [Help]

APPS.PO_PRICE_DIFFERENTIALS_PVT dependencies on PO_LINES_ALL

Line 658: FROM po_lines_all POL

654: INTO x_line_num
655: , x_price_break_num
656: , x_job_name
657: , x_job_description
658: FROM po_lines_all POL
659: , po_line_locations_all POLL
660: , per_jobs_vl PJ
661: , po_job_associations POJA
662: WHERE p_entity_id = POLL.line_location_id

Line 677: FROM po_lines_all POL

673: INTO x_line_num
674: , x_price_break_num
675: , x_job_name
676: , x_job_description
677: FROM po_lines_all POL
678: , per_jobs_vl PJ
679: , po_job_associations POJA
680: WHERE p_entity_id = POL.po_line_id
681: AND POL.job_id = PJ.job_id

Line 1530: l_line_price PO_LINES_ALL.unit_price%TYPE;

1526: , x_price OUT NOCOPY NUMBER
1527: )
1528: IS
1529:
1530: l_line_price PO_LINES_ALL.unit_price%TYPE;
1531: l_multiplier PO_PRICE_DIFFERENTIALS.multiplier%TYPE;
1532:
1533: BEGIN
1534:

Line 1545: FROM po_lines_all

1541: END IF;
1542:
1543: SELECT unit_price
1544: INTO l_line_price
1545: FROM po_lines_all
1546: WHERE po_line_id = p_entity_id;
1547:
1548: Begin
1549: SELECT multiplier

Line 1622: FROM PO_LINES_ALL pol,

1618: INTO l_ga_flag,
1619: l_doc_subtype,
1620: l_value_basis,
1621: l_purchase_basis
1622: FROM PO_LINES_ALL pol,
1623: PO_HEADERS_ALL poh
1624: WHERE poh.po_header_id = pol.po_header_id
1625: AND po_line_id = p_doc_level_id;
1626:

Line 1639: PO_LINES_ALL pol,

1635: l_doc_subtype,
1636: l_value_basis,
1637: l_purchase_basis
1638: FROM PO_HEADERS_ALL poh,
1639: PO_LINES_ALL pol,
1640: PO_LINE_LOCATIONS_ALL poll
1641: WHERE poh.po_header_id = pol.po_header_id
1642: AND pol.po_line_id = poll.po_line_id
1643: AND poll.line_location_id = p_doc_level_id;