510: zx.event_class_code,
511: zx.trx_id,
512: zx.trx_line_id,
513: zx.trx_level_type
514: FROM zx_lines_det_factors zx,
515: ra_customer_trx_all artrx
516: WHERE zx.trx_id = artrx.customer_trx_id
517: AND zx.application_id = 222
518: AND zx.entity_code = 'TRANSACTIONS'
523: ---Bug: 9094846
524:
525:
526: l_payment_method_lookup_code VARCHAR2(30);
527: l_application_id zx_lines_det_factors.application_id%TYPE;
528: l_entity_code zx_lines_det_factors.entity_code%TYPE;
529: l_event_class_code zx_lines_det_factors.event_class_code%TYPE;
530: l_trx_id zx_lines_det_factors.trx_id%TYPE;
531: l_trx_line_id zx_lines_det_factors.trx_line_id%TYPE;
524:
525:
526: l_payment_method_lookup_code VARCHAR2(30);
527: l_application_id zx_lines_det_factors.application_id%TYPE;
528: l_entity_code zx_lines_det_factors.entity_code%TYPE;
529: l_event_class_code zx_lines_det_factors.event_class_code%TYPE;
530: l_trx_id zx_lines_det_factors.trx_id%TYPE;
531: l_trx_line_id zx_lines_det_factors.trx_line_id%TYPE;
532: l_trx_level_type zx_lines_det_factors.trx_level_type%TYPE;
525:
526: l_payment_method_lookup_code VARCHAR2(30);
527: l_application_id zx_lines_det_factors.application_id%TYPE;
528: l_entity_code zx_lines_det_factors.entity_code%TYPE;
529: l_event_class_code zx_lines_det_factors.event_class_code%TYPE;
530: l_trx_id zx_lines_det_factors.trx_id%TYPE;
531: l_trx_line_id zx_lines_det_factors.trx_line_id%TYPE;
532: l_trx_level_type zx_lines_det_factors.trx_level_type%TYPE;
533:
526: l_payment_method_lookup_code VARCHAR2(30);
527: l_application_id zx_lines_det_factors.application_id%TYPE;
528: l_entity_code zx_lines_det_factors.entity_code%TYPE;
529: l_event_class_code zx_lines_det_factors.event_class_code%TYPE;
530: l_trx_id zx_lines_det_factors.trx_id%TYPE;
531: l_trx_line_id zx_lines_det_factors.trx_line_id%TYPE;
532: l_trx_level_type zx_lines_det_factors.trx_level_type%TYPE;
533:
534: --Bug: 13622727
527: l_application_id zx_lines_det_factors.application_id%TYPE;
528: l_entity_code zx_lines_det_factors.entity_code%TYPE;
529: l_event_class_code zx_lines_det_factors.event_class_code%TYPE;
530: l_trx_id zx_lines_det_factors.trx_id%TYPE;
531: l_trx_line_id zx_lines_det_factors.trx_line_id%TYPE;
532: l_trx_level_type zx_lines_det_factors.trx_level_type%TYPE;
533:
534: --Bug: 13622727
535:
528: l_entity_code zx_lines_det_factors.entity_code%TYPE;
529: l_event_class_code zx_lines_det_factors.event_class_code%TYPE;
530: l_trx_id zx_lines_det_factors.trx_id%TYPE;
531: l_trx_line_id zx_lines_det_factors.trx_line_id%TYPE;
532: l_trx_level_type zx_lines_det_factors.trx_level_type%TYPE;
533:
534: --Bug: 13622727
535:
536: --------------------------------------------------------