DBA Data[Home] [Help]

APPS.PO_DELREC_PVT dependencies on PO_RELEASES

Line 305: FROM PO_RELEASES_ALL

301: WHERE po_header_id = p_doc_id;
302: ELSIF ( p_doc_type = 'RELEASE' AND p_doc_subtype = 'BLANKET') THEN
303: SELECT shipping_control
304: INTO l_shipping_control
305: FROM PO_RELEASES_ALL
306: WHERE po_release_id = p_doc_id;
307: ELSE
308: l_shipping_control := NULL;
309: END IF;

Line 876: po_releases_all por,

872: po_line_locations_all pll,
873: rcv_transactions rt,
874: mtl_system_items msi,
875: fnd_lookup_values fl,
876: po_releases_all por,
877: mtl_units_of_measure muom,
878: mtl_units_of_measure suom,
879: mtl_units_of_measure puom,
880: mtl_units_of_measure rtuom,

Line 1171: po_releases_all por,

1167: po_line_locations_all pll,
1168: rcv_transactions rt,
1169: mtl_system_items msi,
1170: fnd_lookup_values fl,
1171: po_releases_all por,
1172: mtl_units_of_measure muom,
1173: mtl_units_of_measure suom,
1174: mtl_units_of_measure puom,
1175: mtl_units_of_measure rtuom,

Line 2544: FROM PO_RELEASES POR,

2540: x_fte_rec.net_weight,
2541: x_fte_rec.weight_uom_code,
2542: x_fte_rec.volume,
2543: x_fte_rec.volume_uom_code
2544: FROM PO_RELEASES POR,
2545: PO_HEADERS POH,
2546: PO_LINES POL,
2547: PO_LINE_LOCATIONS POLL,
2548: PO_LINE_TYPES_B PLT,

Line 2772: FROM PO_RELEASES POR,

2768: x_fte_rec.net_weight,
2769: x_fte_rec.weight_uom_code,
2770: x_fte_rec.volume,
2771: x_fte_rec.volume_uom_code
2772: FROM PO_RELEASES POR,
2773: PO_HEADERS POH,
2774: PO_LINES POL,
2775: PO_LINE_LOCATIONS POLL,
2776: PO_LINE_TYPES_B PLT,

Line 2998: FROM PO_RELEASES POR,

2994: x_fte_rec.net_weight,
2995: x_fte_rec.weight_uom_code,
2996: x_fte_rec.volume,
2997: x_fte_rec.volume_uom_code
2998: FROM PO_RELEASES POR,
2999: PO_HEADERS POH,
3000: PO_LINES POL,
3001: PO_LINE_LOCATIONS POLL,
3002: PO_LINE_TYPES_B PLT,

Line 3225: FROM PO_RELEASES POR,

3221: x_fte_rec.net_weight,
3222: x_fte_rec.weight_uom_code,
3223: x_fte_rec.volume,
3224: x_fte_rec.volume_uom_code
3225: FROM PO_RELEASES POR,
3226: PO_HEADERS POH,
3227: PO_LINES POL,
3228: PO_LINE_LOCATIONS POLL,
3229: PO_LINE_TYPES_B PLT,

Line 3454: FROM PO_RELEASES POR,

3450: x_fte_rec.net_weight,
3451: x_fte_rec.weight_uom_code,
3452: x_fte_rec.volume,
3453: x_fte_rec.volume_uom_code
3454: FROM PO_RELEASES POR,
3455: PO_HEADERS POH,
3456: PO_LINES POL,
3457: PO_LINE_LOCATIONS POLL,
3458: PO_LINE_TYPES_B PLT,