DBA Data[Home] [Help]

APPS.CST_EAMCOST_PUB dependencies on PO_TAX_SV

Line 2790: + PO_TAX_SV.get_tax('PO',pda.po_distribution_id)

2786: (
2787: NVL(pla.order_type_lookup_code,'QUANTITY'),
2788: 'RATE',(
2789: (NVL(wediv.amount,0) - NVL(pda.amount_cancelled,0))
2790: + PO_TAX_SV.get_tax('PO',pda.po_distribution_id)
2791: )
2792: * NVL(wediv.currency_rate,1) ,
2793: 'FIXED PRICE',(
2794: (NVL(wediv.amount,0) - NVL(pda.amount_cancelled,0))

Line 2795: + PO_TAX_SV.get_tax('PO',pda.po_distribution_id)

2791: )
2792: * NVL(wediv.currency_rate,1) ,
2793: 'FIXED PRICE',(
2794: (NVL(wediv.amount,0) - NVL(pda.amount_cancelled,0))
2795: + PO_TAX_SV.get_tax('PO',pda.po_distribution_id)
2796: )
2797: * NVL(wediv.currency_rate,1),
2798: (
2799: NVL(plla.price_override,0) *

Line 2801: + PO_TAX_SV.get_tax('PO',pda.po_distribution_id)

2797: * NVL(wediv.currency_rate,1),
2798: (
2799: NVL(plla.price_override,0) *
2800: (NVL(pda.quantity_ordered,0) - NVL(pda.quantity_cancelled,0))
2801: + PO_TAX_SV.get_tax('PO',pda.po_distribution_id)
2802: )
2803: * NVL(wediv.currency_rate,1)
2804: )), l_ext_precision
2805: ) pda_value,

Line 4880: + PO_TAX_SV.get_tax('PO',pda.po_distribution_id)

4876: FROM (
4877: SELECT decode(NVL(pla.order_type_lookup_code,'QUANTITY'),
4878: 'RATE',(
4879: (NVL(cedi.amount,0) - NVL(pda.amount_cancelled,0))
4880: + PO_TAX_SV.get_tax('PO',pda.po_distribution_id)
4881: )
4882: * NVL(cedi.currency_rate,1),
4883: 'FIXED PRICE',(
4884: (NVL(cedi.amount,0) - NVL(pda.amount_cancelled,0))

Line 4885: + PO_TAX_SV.get_tax('PO',pda.po_distribution_id)

4881: )
4882: * NVL(cedi.currency_rate,1),
4883: 'FIXED PRICE',(
4884: (NVL(cedi.amount,0) - NVL(pda.amount_cancelled,0))
4885: + PO_TAX_SV.get_tax('PO',pda.po_distribution_id)
4886: )
4887: * NVL(cedi.currency_rate,1),
4888: (NVL(plla.price_override,0) *
4889: (NVL(pda.quantity_ordered,0) - NVL(pda.quantity_cancelled,0))

Line 4890: + /* Tax */ PO_TAX_SV.get_tax('PO',pda.po_distribution_id)

4886: )
4887: * NVL(cedi.currency_rate,1),
4888: (NVL(plla.price_override,0) *
4889: (NVL(pda.quantity_ordered,0) - NVL(pda.quantity_cancelled,0))
4890: + /* Tax */ PO_TAX_SV.get_tax('PO',pda.po_distribution_id)
4891: )
4892: * NVL(cedi.currency_rate,1)) estimated_cost,
4893: decode(NVL(pla.order_type_lookup_code,'QUANTITY'),
4894: 'RATE',NVL(cedi.amount,0) ,

Line 5958: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,

5954: Requirements Project - R12 */
5955:
5956: /* SELECT decode(pol.order_type_lookup_code,
5957: 'RATE', rti.amount + rti.amount *
5958: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,
5959: 'FIXED PRICE', rti.amount + rti.amount *
5960: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,
5961: (rti.po_unit_price +
5962: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.quantity_ordered)),

Line 5960: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,

5956: /* SELECT decode(pol.order_type_lookup_code,
5957: 'RATE', rti.amount + rti.amount *
5958: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,
5959: 'FIXED PRICE', rti.amount + rti.amount *
5960: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,
5961: (rti.po_unit_price +
5962: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.quantity_ordered)),
5963: nvl(l_directItem_rec.currency_conversion_rate,nvl(rti.currency_conversion_rate,1)),
5964: rti.currency_code,

Line 5962: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.quantity_ordered)),

5958: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,
5959: 'FIXED PRICE', rti.amount + rti.amount *
5960: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,
5961: (rti.po_unit_price +
5962: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.quantity_ordered)),
5963: nvl(l_directItem_rec.currency_conversion_rate,nvl(rti.currency_conversion_rate,1)),
5964: rti.currency_code,
5965: pol.order_type_lookup_code
5966: into l_actual_res_rate,

Line 5983: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,

5979: l_stmt_num := 30;
5980:
5981: select decode(pol.order_type_lookup_code,
5982: 'RATE', rti.amount + rti.amount *
5983: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,
5984: 'FIXED PRICE', rti.amount + rti.amount *
5985: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,
5986: (rti.po_unit_price +
5987: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.quantity_ordered)),

Line 5985: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,

5981: select decode(pol.order_type_lookup_code,
5982: 'RATE', rti.amount + rti.amount *
5983: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,
5984: 'FIXED PRICE', rti.amount + rti.amount *
5985: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,
5986: (rti.po_unit_price +
5987: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.quantity_ordered)),
5988: nvl(l_directItem_rec.currency_conversion_rate,nvl(rti.currency_conversion_rate,1)),
5989: rti.currency_code,

Line 5987: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.quantity_ordered)),

5983: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,
5984: 'FIXED PRICE', rti.amount + rti.amount *
5985: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.amount_ordered,
5986: (rti.po_unit_price +
5987: PO_TAX_SV.get_tax('PO',pod.po_distribution_id)/pod.quantity_ordered)),
5988: nvl(l_directItem_rec.currency_conversion_rate,nvl(rti.currency_conversion_rate,1)),
5989: rti.currency_code,
5990: pol.order_type_lookup_code,
5991: 1,