DBA Data[Home] [Help]

APPS.PO_VAL_LINES2 dependencies on PO_LINES_ALL

Line 2357: FROM po_lines_all pln

2353: FROM DUAL
2354: WHERE p_po_header_id_tbl(i) IS NOT NULL
2355: AND p_line_num_tbl(i) IS NOT NULL
2356: AND (EXISTS(SELECT 'Y'
2357: FROM po_lines_all pln
2358: WHERE pln.po_header_id = p_po_header_id_tbl(i)
2359: AND pln.line_num = p_line_num_tbl(i)
2360: AND NOT EXISTS (SELECT 'Y'
2361: FROM po_lines_draft_all PLD

Line 3286: -- We need to validate UOM against po_lines_all and po_units_of_measure_val_v

3282: RAISE;
3283: END ip_category_id_update;
3284:
3285: -----------------------------------------------------------------------------
3286: -- We need to validate UOM against po_lines_all and po_units_of_measure_val_v
3287: -----------------------------------------------------------------------------
3288: PROCEDURE uom_update(
3289: p_id_tbl IN po_tbl_number,
3290: p_unit_meas_lookup_code_tbl IN po_tbl_varchar30,

Line 3355: FROM po_lines_all pol

3351: PO_VAL_CONSTANTS.c_uom_update_valid
3352: FROM DUAL
3353: WHERE EXISTS(
3354: SELECT 1
3355: FROM po_lines_all pol
3356: WHERE po_header_id = p_po_header_id_tbl(i) AND
3357: po_line_id = p_po_line_id_tbl(i) AND
3358: p_unit_meas_lookup_code_tbl(i) IS NOT NULL AND
3359: p_unit_meas_lookup_code_tbl(i) <> NVL(pol.unit_meas_lookup_code,

Line 3365: FROM po_lines_all pol

3361: p_unit_meas_lookup_code_tbl(i) NOT IN --- Bug#13936604
3362: (select unit_of_measure from po_units_of_measure_val_v))
3363: OR EXISTS(
3364: SELECT 1
3365: FROM po_lines_all pol
3366: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE') AND
3367: po_header_id = p_po_header_id_tbl(i) AND
3368: po_line_id = p_po_line_id_tbl(i) AND
3369: pol.unit_meas_lookup_code IS NULL AND

Line 3394: -- Also need to check the value in po_lines_all to make sure it is the same there, if necessary.

3390:
3391: -------------------------------------------------------------------------
3392: -- Make sure that the item_description can be different from what is setup in the item master.
3393: -- Would not allow item_description update if item attribute allow_item_desc_update_flag is N.
3394: -- Also need to check the value in po_lines_all to make sure it is the same there, if necessary.
3395: -------------------------------------------------------------------------
3396: PROCEDURE item_desc_update(
3397: p_id_tbl IN po_tbl_number,
3398: p_item_description_tbl IN po_tbl_varchar2000,

Line 3466: po_lines_all pol,

3462: FROM DUAL
3463: WHERE EXISTS(
3464: SELECT 1
3465: FROM mtl_system_items msi,
3466: po_lines_all pol,
3467: mtl_system_items_tl mtl
3468: WHERE p_po_line_id_tbl(i) IS NOT NULL AND
3469: p_item_id_tbl(i) IS NOT NULL AND
3470: pol.po_header_id = nvl(p_po_header_id_tbl(i),pol.po_header_id) AND

Line 3691: FROM po_lines_all pol

3687: FROM DUAL
3688: WHERE p_category_id_tbl(i) IS NOT NULL
3689: AND (p_item_id_tbl(i) IS NOT NULL OR p_job_id_tbl(i) IS NOT NULL)
3690: AND (EXISTS(SELECT 1
3691: FROM po_lines_all pol
3692: WHERE p_po_line_id_tbl(i) = pol.po_line_id
3693: AND p_category_id_tbl(i) <> pol.category_id)
3694: OR EXISTS(SELECT 1
3695: FROM po_lines_draft_all pld

Line 3807: FROM po_lines_all POL

3803: 'PO_PDOI_SVC_NO_PRICE',
3804: 'UNIT_PRICE',
3805: p_unit_price_tbl(i),
3806: PO_VAL_CONSTANTS.c_unit_price_null
3807: FROM po_lines_all POL
3808: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3809: AND POL.order_type_lookup_code = 'FIXED PRICE'
3810: AND p_unit_price_tbl(i) IS NOT NULL
3811: -- missin draft id

Line 3859: FROM po_lines_all POL

3855: p_unit_price_tbl(i),
3856: 'UNIT_PRICE',
3857: p_unit_price_tbl(i),
3858: PO_VAL_CONSTANTS.c_not_to_exceed_price_valid
3859: FROM po_lines_all POL
3860: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3861: AND POL.not_to_exceed_price < p_unit_price_tbl(i);
3862:
3863: IF (SQL%ROWCOUNT > 0) THEN

Line 3887: FROM po_lines_all POL

3883: 'PO_PDOI_ADJ_PRICE_UPDATE_NA',
3884: 'UNIT_PRICE',
3885: p_unit_price_tbl(i),
3886: PO_VAL_CONSTANTS.c_price_adjustment_exist
3887: FROM po_lines_all POL
3888: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3889: AND POL.unit_price <> p_unit_price_tbl(i)
3890: AND EXISTS (SELECT 1
3891: FROM PO_PRICE_ADJUSTMENTS ADJ

Line 3964: FROM po_lines_all POL

3960: 'PO_PDOI_SVC_BLKT_NO_AMT',
3961: 'AMOUNT',
3962: p_amount_tbl(i),
3963: PO_VAL_CONSTANTS.c_amount_blanket
3964: FROM po_lines_all POL
3965: WHERE POL.po_line_id = p_po_line_id_tbl(i)
3966: AND POL.order_type_lookup_code <> 'FIXED PRICE'
3967: AND p_amount_tbl(i) IS NOT NULL
3968: -- missin draft id