eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PMI_SALES_PKG dependencies on OP_ORDR_DTL

Line 38: OP_ORDR_DTL orderdetail,

34: orderdetail.extended_price,orderdetail.billing_currency,orderdetail.base_currency,
35: orderdetail.exchange_rate,orderdetail.mul_div_sign)) Margin
36: FROM
37: OP_ORDR_HDR orderhdr,
38: OP_ORDR_DTL orderdetail,
39: IC_ITEM_MST itemmst
40: WHERE orderhdr.order_id = orderdetail.order_id
41: AND orderdetail.item_id = itemmst.item_id
42: AND trunc(orderdetail.ACTUAL_SHIPDATE)

Line 68: OP_ORDR_DTL orderdetail,

64: orderdetail.extended_price,orderdetail.billing_currency,orderdetail.base_currency,
65: orderdetail.exchange_rate,orderdetail.mul_div_sign)) Margin
66: FROM
67: OP_ORDR_HDR orderhdr,
68: OP_ORDR_DTL orderdetail,
69: IC_ITEM_MST itemmst
70: WHERE orderhdr.order_id = orderdetail.order_id
71: AND orderdetail.item_id = itemmst.item_id
72: AND trunc(orderdetail.ACTUAL_SHIPDATE)

Line 220: OP_ORDR_DTL orderdetail,

216: orderdetail.extended_price,orderdetail.billing_currency,orderdetail.base_currency,
217: orderdetail.exchange_rate,orderdetail.mul_div_sign) line_Margin
218: FROM
219: OP_ORDR_HDR orderhdr,
220: OP_ORDR_DTL orderdetail,
221: IC_ITEM_MST itemmst,
222: SY_ORGN_MST org,
223: GL_PLCY_MST pol
224: WHERE orderhdr.order_id = orderdetail.order_id

Line 306: OP_ORDR_DTL orderdetail,

302: orderdetail.extended_price,orderdetail.billing_currency,orderdetail.base_currency,
303: orderdetail.exchange_rate,orderdetail.mul_div_sign) line_Margin
304: FROM
305: OP_ORDR_HDR orderhdr,
306: OP_ORDR_DTL orderdetail,
307: IC_ITEM_MST itemmst,
308: SY_ORGN_MST org,
309: GL_PLCY_MST pol
310: WHERE orderhdr.order_id = orderdetail.order_id

Line 517: FUNCTION PMISA_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,

513: END IF;
514: END PMISA_VALIDATE_DATE;
515:
516: /* Function to calculate Charges for a given order line , Refer Package Spec for Details Description */
517: FUNCTION PMISA_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,
518: p_Line_id IN op_ordr_dtl.line_id%TYPE,
519: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
520: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
521: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,

Line 518: p_Line_id IN op_ordr_dtl.line_id%TYPE,

514: END PMISA_VALIDATE_DATE;
515:
516: /* Function to calculate Charges for a given order line , Refer Package Spec for Details Description */
517: FUNCTION PMISA_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,
518: p_Line_id IN op_ordr_dtl.line_id%TYPE,
519: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
520: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
521: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
522: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,

Line 519: p_extended_price IN op_ordr_dtl.extended_price%TYPE,

515:
516: /* Function to calculate Charges for a given order line , Refer Package Spec for Details Description */
517: FUNCTION PMISA_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,
518: p_Line_id IN op_ordr_dtl.line_id%TYPE,
519: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
520: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
521: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
522: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,
523: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE

Line 520: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,

516: /* Function to calculate Charges for a given order line , Refer Package Spec for Details Description */
517: FUNCTION PMISA_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,
518: p_Line_id IN op_ordr_dtl.line_id%TYPE,
519: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
520: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
521: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
522: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,
523: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE
524: )

Line 521: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,

517: FUNCTION PMISA_GET_CHARGE ( p_Order_id IN op_ordr_dtl.order_id%TYPE,
518: p_Line_id IN op_ordr_dtl.line_id%TYPE,
519: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
520: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
521: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
522: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,
523: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE
524: )
525: RETURN NUMBER IS

Line 522: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,

518: p_Line_id IN op_ordr_dtl.line_id%TYPE,
519: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
520: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
521: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
522: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,
523: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE
524: )
525: RETURN NUMBER IS
526: /* Cursor to find changes for order and line */

Line 523: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE

519: p_extended_price IN op_ordr_dtl.extended_price%TYPE,
520: p_Billing_Currency IN op_ordr_dtl.billing_currency%TYPE,
521: p_Base_Currency IN op_ordr_dtl.BASE_CURRENCY%TYPE,
522: p_exchange_Rate IN op_ordr_dtl.EXCHANGE_RATE%TYPE,
523: p_mul_div_sign IN op_ordr_dtl.mul_div_sign%TYPE
524: )
525: RETURN NUMBER IS
526: /* Cursor to find changes for order and line */
527: /* SUM added in case multiple charge lines are returned for a line_id. -PDONG 01-31-02 */

Line 529: CURSOR cur_line_charge(P_order_id op_ordr_dtl.order_id%TYPE,

525: RETURN NUMBER IS
526: /* Cursor to find changes for order and line */
527: /* SUM added in case multiple charge lines are returned for a line_id. -PDONG 01-31-02 */
528:
529: CURSOR cur_line_charge(P_order_id op_ordr_dtl.order_id%TYPE,
530: P_line_id op_ordr_dtl.line_id%TYPE,
531: P_base_currency op_ordr_dtl.BASE_CURRENCY%TYPE,
532: p_billing_currency op_ordr_dtl.billing_currency%TYPE,
533: p_exchange_rate op_ordr_dtl.EXCHANGE_RATE%TYPE,

Line 530: P_line_id op_ordr_dtl.line_id%TYPE,

526: /* Cursor to find changes for order and line */
527: /* SUM added in case multiple charge lines are returned for a line_id. -PDONG 01-31-02 */
528:
529: CURSOR cur_line_charge(P_order_id op_ordr_dtl.order_id%TYPE,
530: P_line_id op_ordr_dtl.line_id%TYPE,
531: P_base_currency op_ordr_dtl.BASE_CURRENCY%TYPE,
532: p_billing_currency op_ordr_dtl.billing_currency%TYPE,
533: p_exchange_rate op_ordr_dtl.EXCHANGE_RATE%TYPE,
534: p_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE)

Line 531: P_base_currency op_ordr_dtl.BASE_CURRENCY%TYPE,

527: /* SUM added in case multiple charge lines are returned for a line_id. -PDONG 01-31-02 */
528:
529: CURSOR cur_line_charge(P_order_id op_ordr_dtl.order_id%TYPE,
530: P_line_id op_ordr_dtl.line_id%TYPE,
531: P_base_currency op_ordr_dtl.BASE_CURRENCY%TYPE,
532: p_billing_currency op_ordr_dtl.billing_currency%TYPE,
533: p_exchange_rate op_ordr_dtl.EXCHANGE_RATE%TYPE,
534: p_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE)
535: IS

Line 532: p_billing_currency op_ordr_dtl.billing_currency%TYPE,

528:
529: CURSOR cur_line_charge(P_order_id op_ordr_dtl.order_id%TYPE,
530: P_line_id op_ordr_dtl.line_id%TYPE,
531: P_base_currency op_ordr_dtl.BASE_CURRENCY%TYPE,
532: p_billing_currency op_ordr_dtl.billing_currency%TYPE,
533: p_exchange_rate op_ordr_dtl.EXCHANGE_RATE%TYPE,
534: p_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE)
535: IS
536: SELECT SUM(abs(DECODE(P_Base_Currency,p_Billing_Currency,

Line 533: p_exchange_rate op_ordr_dtl.EXCHANGE_RATE%TYPE,

529: CURSOR cur_line_charge(P_order_id op_ordr_dtl.order_id%TYPE,
530: P_line_id op_ordr_dtl.line_id%TYPE,
531: P_base_currency op_ordr_dtl.BASE_CURRENCY%TYPE,
532: p_billing_currency op_ordr_dtl.billing_currency%TYPE,
533: p_exchange_rate op_ordr_dtl.EXCHANGE_RATE%TYPE,
534: p_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE)
535: IS
536: SELECT SUM(abs(DECODE(P_Base_Currency,p_Billing_Currency,
537: Extended_amount,

Line 534: p_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE)

530: P_line_id op_ordr_dtl.line_id%TYPE,
531: P_base_currency op_ordr_dtl.BASE_CURRENCY%TYPE,
532: p_billing_currency op_ordr_dtl.billing_currency%TYPE,
533: p_exchange_rate op_ordr_dtl.EXCHANGE_RATE%TYPE,
534: p_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE)
535: IS
536: SELECT SUM(abs(DECODE(P_Base_Currency,p_Billing_Currency,
537: Extended_amount,
538: Decode(p_mul_div_sign,0,Extended_amount*p_Exchange_Rate,

Line 548: CURSOR cur_order_charge(P_order_id op_ordr_dtl.order_id%TYPE,

544: AND a.charge_id = b.charge_id
545: AND b.charge_type in (20,30);
546:
547: /* Cursor to find changes for order */
548: CURSOR cur_order_charge(P_order_id op_ordr_dtl.order_id%TYPE,
549: P_base_currency op_ordr_dtl.BASE_CURRENCY%TYPE,
550: p_billing_currency op_ordr_dtl.billing_currency%TYPE,
551: p_exchange_rate op_ordr_dtl.EXCHANGE_RATE%TYPE,
552: p_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE)

Line 549: P_base_currency op_ordr_dtl.BASE_CURRENCY%TYPE,

545: AND b.charge_type in (20,30);
546:
547: /* Cursor to find changes for order */
548: CURSOR cur_order_charge(P_order_id op_ordr_dtl.order_id%TYPE,
549: P_base_currency op_ordr_dtl.BASE_CURRENCY%TYPE,
550: p_billing_currency op_ordr_dtl.billing_currency%TYPE,
551: p_exchange_rate op_ordr_dtl.EXCHANGE_RATE%TYPE,
552: p_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE)
553: IS

Line 550: p_billing_currency op_ordr_dtl.billing_currency%TYPE,

546:
547: /* Cursor to find changes for order */
548: CURSOR cur_order_charge(P_order_id op_ordr_dtl.order_id%TYPE,
549: P_base_currency op_ordr_dtl.BASE_CURRENCY%TYPE,
550: p_billing_currency op_ordr_dtl.billing_currency%TYPE,
551: p_exchange_rate op_ordr_dtl.EXCHANGE_RATE%TYPE,
552: p_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE)
553: IS
554: SELECT sum(abs(DECODE(P_Base_Currency,p_Billing_Currency,

Line 551: p_exchange_rate op_ordr_dtl.EXCHANGE_RATE%TYPE,

547: /* Cursor to find changes for order */
548: CURSOR cur_order_charge(P_order_id op_ordr_dtl.order_id%TYPE,
549: P_base_currency op_ordr_dtl.BASE_CURRENCY%TYPE,
550: p_billing_currency op_ordr_dtl.billing_currency%TYPE,
551: p_exchange_rate op_ordr_dtl.EXCHANGE_RATE%TYPE,
552: p_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE)
553: IS
554: SELECT sum(abs(DECODE(P_Base_Currency,p_Billing_Currency,
555: Extended_amount,

Line 552: p_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE)

548: CURSOR cur_order_charge(P_order_id op_ordr_dtl.order_id%TYPE,
549: P_base_currency op_ordr_dtl.BASE_CURRENCY%TYPE,
550: p_billing_currency op_ordr_dtl.billing_currency%TYPE,
551: p_exchange_rate op_ordr_dtl.EXCHANGE_RATE%TYPE,
552: p_mul_div_sign op_ordr_dtl.mul_div_sign%TYPE)
553: IS
554: SELECT sum(abs(DECODE(P_Base_Currency,p_Billing_Currency,
555: Extended_amount,
556: Decode(p_mul_div_sign,0,Extended_amount*p_Exchange_Rate,

Line 566: CURSOR cur_order_value(P_order_id op_ordr_dtl.order_id%TYPE)

562: AND b.charge_type in (20,30);
563:
564: /*Cursor to find total value for order*/
565:
566: CURSOR cur_order_value(P_order_id op_ordr_dtl.order_id%TYPE)
567: IS
568: SELECT SUM(DECODE(Base_Currency,Billing_Currency,
569: Extended_price,
570: Decode(mul_div_sign,0,Extended_price*Exchange_Rate,

Line 572: FROM op_ordr_dtl

568: SELECT SUM(DECODE(Base_Currency,Billing_Currency,
569: Extended_price,
570: Decode(mul_div_sign,0,Extended_price*Exchange_Rate,
571: Extended_price/Exchange_Rate)))
572: FROM op_ordr_dtl
573: WHERE order_id = P_order_id;
574:
575: l_line_charge NUMBER;
576: l_order_value NUMBER;