DBA Data[Home] [Help]

APPS.PO_RELGEN_PKG dependencies on PO_LINE_TYPES

Line 1720: po_line_types plt

1716: IF (req_line.blanket_po_line_id is not NULL) THEN
1717: select nvl(rcv_controls.receipt_required_flag,plt.receiving_flag)
1718: into rcv_controls.receipt_required_flag
1719: from po_lines pol,
1720: po_line_types plt
1721: where pol.po_line_id = req_line.blanket_po_line_id
1722: and pol.line_type_id = plt.line_type_id;
1723: END IF;
1724:

Line 1732: po_line_types plt

1728:
1729: select nvl(rcv_controls.receipt_close_tolerance, plt.receive_close_tolerance)
1730: into rcv_controls.receipt_close_tolerance
1731: from po_lines pol,
1732: po_line_types plt
1733: where pol.po_line_id = req_line.blanket_po_line_id
1734: and pol.line_type_id = plt.line_type_id;
1735: END IF;
1736: -- End fix4388305(forward fix4379167)

Line 2528: PO_LINE_TYPES PLT,

2524: nvl(POLL.quantity,0) quantity,
2525: nvl(POL.item_id,0) item_id,
2526: nvl( POLL.line_location_id,0) line_loc_id
2527: FROM PO_LINE_LOCATIONS POLL,
2528: PO_LINE_TYPES PLT,
2529: PO_LINES POL,
2530: PO_DISTRIBUTIONS POD
2531: WHERE POLL.po_line_id = POL.po_line_id
2532: AND POLL.line_location_id = POD.line_location_id