DBA Data[Home] [Help]

APPS.PO_VAL_DISTRIBUTIONS dependencies on STANDARD

Line 8: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';

4: c_ENTITY_TYPE_DISTRIBUTION CONSTANT VARCHAR2(30) := PO_VALIDATIONS.C_ENTITY_TYPE_DISTRIBUTION;
5: c_NEW CONSTANT VARCHAR2(3) := 'NEW';
6: c_RATE CONSTANT VARCHAR2(30) := 'RATE';
7: c_FIXED_PRICE CONSTANT VARCHAR2(30) := 'FIXED PRICE';
8: c_STANDARD CONSTANT VARCHAR2(30) := 'STANDARD';
9: c_PREPAYMENT CONSTANT VARCHAR2(30) := 'PREPAYMENT'; --
10: c_DEST_TYPE_SHOP_FLOOR CONSTANT VARCHAR2(30) := 'SHOP FLOOR';
11: c_DEST_TYPE_EXPENSE CONSTANT VARCHAR2(30) := 'EXPENSE';
12: c_DEST_TYPE_INVENTORY CONSTANT VARCHAR2(30) :='INVENTORY';

Line 242: AND p_dist_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT) --

238: FROM
239: PO_DISTRIBUTIONS_ALL POD
240: WHERE
241: POD.po_distribution_id = p_dist_id_tbl(i)
242: AND p_dist_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT) --
243: -- Quantity is being reduced below the current transaction quantity:
244: AND p_qty_ordered_tbl(i) < POD.quantity_ordered
245: AND p_qty_ordered_tbl(i) < --
246: GREATEST(NVL(POD.quantity_delivered, 0),

Line 378: AND p_dist_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT) --

374: FROM
375: PO_DISTRIBUTIONS_ALL POD
376: WHERE
377: POD.po_distribution_id = p_dist_id_tbl(i)
378: AND p_dist_type_tbl(i) IN (c_STANDARD, c_PREPAYMENT) --
379: -- Amount is being reduced below the current transaction amount:
380: AND p_amt_ordered_tbl(i) < POD.amount_ordered
381: AND p_amt_ordered_tbl(i) < GREATEST(NVL(POD.amount_delivered, 0),
382: NVL(POD.amount_financed, 0),

Line 869: -- For Standard POs only.

865:
866: ------------------------------------------------------------------------
867: -- ECO 4059111
868: -- Performs the federal financial validations for distributions
869: -- For Standard POs only.
870: ------------------------------------------------------------------------
871: PROCEDURE check_fv_validations(
872: p_dist_id_tbl IN PO_TBL_NUMBER
873: , p_ccid_tbl IN PO_TBL_NUMBER