DBA Data[Home] [Help]

APPS.PO_RELGEN_PKG dependencies on PO_LINE_TYPES

Line 1704: po_line_types plt

1700: IF (req_line.blanket_po_line_id is not NULL) THEN
1701: select nvl(rcv_controls.receipt_required_flag,plt.receiving_flag)
1702: into rcv_controls.receipt_required_flag
1703: from po_lines pol,
1704: po_line_types plt
1705: where pol.po_line_id = req_line.blanket_po_line_id
1706: and pol.line_type_id = plt.line_type_id;
1707: END IF;
1708:

Line 1716: po_line_types plt

1712:
1713: select nvl(rcv_controls.receipt_close_tolerance, plt.receive_close_tolerance)
1714: into rcv_controls.receipt_close_tolerance
1715: from po_lines pol,
1716: po_line_types plt
1717: where pol.po_line_id = req_line.blanket_po_line_id
1718: and pol.line_type_id = plt.line_type_id;
1719: END IF;
1720: -- End fix4388305(forward fix4379167)

Line 2503: PO_LINE_TYPES PLT,

2499: nvl(POLL.quantity,0) quantity,
2500: nvl(POL.item_id,0) item_id,
2501: nvl( POLL.line_location_id,0) line_loc_id
2502: FROM PO_LINE_LOCATIONS POLL,
2503: PO_LINE_TYPES PLT,
2504: PO_LINES POL,
2505: PO_DISTRIBUTIONS POD
2506: WHERE POLL.po_line_id = POL.po_line_id
2507: AND POLL.line_location_id = POD.line_location_id