[Home] [Help]
2724:
2725: IF l_order_line_id IS NOT NULL THEN
2726: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
2727: INTO l_invoice_line_id
2728: FROM ra_customer_trx_lines_all rctl,
2729: ra_customer_trx rct,
2730: ar_lookups arlup
2731: WHERE rct.status_trx = arlup.lookup_code
2732: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'
2725: IF l_order_line_id IS NOT NULL THEN
2726: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
2727: INTO l_invoice_line_id
2728: FROM ra_customer_trx_lines_all rctl,
2729: ra_customer_trx rct,
2730: ar_lookups arlup
2731: WHERE rct.status_trx = arlup.lookup_code
2732: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'
2733: AND rct.customer_trx_id = rctl.customer_trx_id
2755:
2756: BEGIN
2757: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
2758: INTO l_invoice_line_id
2759: FROM ra_customer_trx_lines_all rctl,
2760: ra_customer_trx rct,
2761: ar_lookups arlup
2762: WHERE rct.status_trx = arlup.lookup_code
2763: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'
2756: BEGIN
2757: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
2758: INTO l_invoice_line_id
2759: FROM ra_customer_trx_lines_all rctl,
2760: ra_customer_trx rct,
2761: ar_lookups arlup
2762: WHERE rct.status_trx = arlup.lookup_code
2763: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'
2764: AND rct.customer_trx_id = rctl.customer_trx_id
2910: /* Modified the following query to put the ivoice currency check for the bug 6916542 */
2911:
2912: SELECT /* MOAC_SQL_CHANGE */ to_number(rctl.interface_line_attribute6)
2913: INTO p_ref_line_id
2914: FROM ra_customer_trx_lines_all rctl,
2915: ra_customer_trx_all rct,
2916: oe_order_lines_all l,
2917: oe_order_headers h
2918: WHERE to_number(p_return_attribute2) = rctl.customer_trx_line_id
2911:
2912: SELECT /* MOAC_SQL_CHANGE */ to_number(rctl.interface_line_attribute6)
2913: INTO p_ref_line_id
2914: FROM ra_customer_trx_lines_all rctl,
2915: ra_customer_trx_all rct,
2916: oe_order_lines_all l,
2917: oe_order_headers h
2918: WHERE to_number(p_return_attribute2) = rctl.customer_trx_line_id
2919: and rctl.customer_trx_id = rct.customer_trx_id
3178: END IF;
3179: BEGIN
3180: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
3181: INTO l_invoice_line_id
3182: FROM ra_customer_trx_lines_all rctl,
3183: ra_customer_trx rct,
3184: ar_lookups arlup
3185: WHERE rct.status_trx = arlup.lookup_code
3186: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'
3179: BEGIN
3180: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
3181: INTO l_invoice_line_id
3182: FROM ra_customer_trx_lines_all rctl,
3183: ra_customer_trx rct,
3184: ar_lookups arlup
3185: WHERE rct.status_trx = arlup.lookup_code
3186: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'
3187: AND rct.customer_trx_id = rctl.customer_trx_id
3247: BEGIN
3248:
3249: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
3250: INTO l_invoice_line_id
3251: FROM ra_customer_trx_lines_all rctl,
3252: ra_customer_trx rct,
3253: ar_lookups arlup
3254: WHERE rct.status_trx = arlup.lookup_code
3255: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'
3248:
3249: SELECT /* MOAC_SQL_CHANGE */ rctl.customer_trx_line_id
3250: INTO l_invoice_line_id
3251: FROM ra_customer_trx_lines_all rctl,
3252: ra_customer_trx rct,
3253: ar_lookups arlup
3254: WHERE rct.status_trx = arlup.lookup_code
3255: AND arlup.lookup_type = 'INVOICE_TRX_STATUS'
3256: AND rct.customer_trx_id = rctl.customer_trx_id
3351: BEGIN
3352:
3353: SELECT to_number(rctl.interface_line_attribute6)
3354: INTO l_order_line_id
3355: FROM ra_customer_trx_lines rctl
3356: WHERE to_number(p_return_attribute2) = rctl.customer_trx_line_id;
3357:
3358: RETURN l_order_line_id;
3359:
3404: l_tax_exempt_flag,
3405: l_tax_exempt_reason_code,
3406: l_tax_exempt_number,
3407: l_uom_code
3408: FROM ra_customer_trx_lines_all rctl,
3409: oe_order_lines l
3410: WHERE rctl.customer_trx_line_id = p_invoice_line_id
3411: AND to_number(rctl.interface_line_attribute6) = l.line_id;
3412: EXCEPTION