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.XLA_00707_AAD_S_000005_BC_PKG dependencies on FND_LOOKUP_VALUES

Line 6077: , fnd_lookup_values fvl13

6073: , CST_XLA_RCV_REF_V h3
6074: , PO_DISTS_REF_V h4
6075: , PO_HEADERS_REF_V h5
6076: , PSA_CST_XLA_UPG_V h6
6077: , fnd_lookup_values fvl13
6078: , fnd_lookup_values fvl37
6079: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
6080: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6081: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 6078: , fnd_lookup_values fvl37

6074: , PO_DISTS_REF_V h4
6075: , PO_HEADERS_REF_V h5
6076: , PSA_CST_XLA_UPG_V h6
6077: , fnd_lookup_values fvl13
6078: , fnd_lookup_values fvl37
6079: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
6080: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
6081: AND xet.event_class_code = C_EVENT_CLASS_CODE
6082: AND h1.event_id = xet.event_id

Line 6324: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

6320: l_balance_type_code VARCHAR2(1) :=NULL;
6321: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
6322:
6323: --
6324: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
6325: --
6326:
6327: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
6328: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 6419: , fnd_lookup_values fvl13

6415: , CST_XLA_RCV_REF_V h3
6416: , PO_DISTS_REF_V h4
6417: , PO_HEADERS_REF_V h5
6418: , PSA_CST_XLA_UPG_V h6
6419: , fnd_lookup_values fvl13
6420: , fnd_lookup_values fvl37
6421: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
6422: and xet.event_class_code = C_EVENT_CLASS_CODE
6423: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 6420: , fnd_lookup_values fvl37

6416: , PO_DISTS_REF_V h4
6417: , PO_HEADERS_REF_V h5
6418: , PSA_CST_XLA_UPG_V h6
6419: , fnd_lookup_values fvl13
6420: , fnd_lookup_values fvl37
6421: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
6422: and xet.event_class_code = C_EVENT_CLASS_CODE
6423: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
6424: AND h3.REF_RCV_ACCOUNTING_EVENT_ID = h1.RCV_ACCOUNTING_EVENT_ID AND h3.po_header_id = h4.po_header_id (+) AND h3.po_distribution_id = h4.po_distribution_id (+) AND h3.po_header_id = h5.po_header_id (+) AND h3.rcv_transaction_id = h6.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 7373: , fnd_lookup_values fvl13

7369: , CST_XLA_INV_REF_V h4
7370: , PO_REQ_DISTS_REF_V h5
7371: , PO_REQ_HEADERS_REF_V h6
7372: , PSA_CST_XLA_UPG_V h7
7373: , fnd_lookup_values fvl13
7374: , fnd_lookup_values fvl37
7375: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
7376: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7377: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 7374: , fnd_lookup_values fvl37

7370: , PO_REQ_DISTS_REF_V h5
7371: , PO_REQ_HEADERS_REF_V h6
7372: , PSA_CST_XLA_UPG_V h7
7373: , fnd_lookup_values fvl13
7374: , fnd_lookup_values fvl37
7375: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
7376: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
7377: AND xet.event_class_code = C_EVENT_CLASS_CODE
7378: AND h1.event_id = xet.event_id

Line 7620: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

7616: l_balance_type_code VARCHAR2(1) :=NULL;
7617: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
7618:
7619: --
7620: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
7621: --
7622:
7623: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
7624: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 7716: , fnd_lookup_values fvl13

7712: , CST_XLA_INV_REF_V h4
7713: , PO_REQ_DISTS_REF_V h5
7714: , PO_REQ_HEADERS_REF_V h6
7715: , PSA_CST_XLA_UPG_V h7
7716: , fnd_lookup_values fvl13
7717: , fnd_lookup_values fvl37
7718: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
7719: and xet.event_class_code = C_EVENT_CLASS_CODE
7720: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 7717: , fnd_lookup_values fvl37

7713: , PO_REQ_DISTS_REF_V h5
7714: , PO_REQ_HEADERS_REF_V h6
7715: , PSA_CST_XLA_UPG_V h7
7716: , fnd_lookup_values fvl13
7717: , fnd_lookup_values fvl37
7718: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
7719: and xet.event_class_code = C_EVENT_CLASS_CODE
7720: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
7721: AND h3.INV_ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h4.ref_transaction_id = h1.transaction_id AND h4.BUS_FLOW_REQ_DIST_ID=h5.REQ_DISTRIBUTION_ID (+) AND h4.BUS_FLOW_REQ_ID = h6.REQ_ID (+) AND h4.rcv_transaction_id = h7.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 8636: , fnd_lookup_values fvl13

8632: , CST_XLA_INV_REF_V h4
8633: , PO_REQ_DISTS_REF_V h5
8634: , PO_REQ_HEADERS_REF_V h6
8635: , PSA_CST_XLA_UPG_V h7
8636: , fnd_lookup_values fvl13
8637: , fnd_lookup_values fvl37
8638: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
8639: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
8640: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 8637: , fnd_lookup_values fvl37

8633: , PO_REQ_DISTS_REF_V h5
8634: , PO_REQ_HEADERS_REF_V h6
8635: , PSA_CST_XLA_UPG_V h7
8636: , fnd_lookup_values fvl13
8637: , fnd_lookup_values fvl37
8638: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
8639: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
8640: AND xet.event_class_code = C_EVENT_CLASS_CODE
8641: AND h1.event_id = xet.event_id

Line 8888: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

8884: l_balance_type_code VARCHAR2(1) :=NULL;
8885: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
8886:
8887: --
8888: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
8889: --
8890:
8891: TYPE t_array_source_4 IS TABLE OF CST_XLA_INV_ORG_PARAMS_REF_V.ENCUMBRANCE_REVERSAL_FLAG%TYPE INDEX BY BINARY_INTEGER;
8892: TYPE t_array_source_7 IS TABLE OF CST_XLA_INV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 8986: , fnd_lookup_values fvl13

8982: , CST_XLA_INV_REF_V h4
8983: , PO_REQ_DISTS_REF_V h5
8984: , PO_REQ_HEADERS_REF_V h6
8985: , PSA_CST_XLA_UPG_V h7
8986: , fnd_lookup_values fvl13
8987: , fnd_lookup_values fvl37
8988: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
8989: and xet.event_class_code = C_EVENT_CLASS_CODE
8990: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 8987: , fnd_lookup_values fvl37

8983: , PO_REQ_DISTS_REF_V h5
8984: , PO_REQ_HEADERS_REF_V h6
8985: , PSA_CST_XLA_UPG_V h7
8986: , fnd_lookup_values fvl13
8987: , fnd_lookup_values fvl37
8988: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
8989: and xet.event_class_code = C_EVENT_CLASS_CODE
8990: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
8991: AND h3.INV_ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h4.ref_transaction_id = h1.transaction_id AND h4.BUS_FLOW_REQ_DIST_ID=h5.REQ_DISTRIBUTION_ID (+) AND h4.BUS_FLOW_REQ_ID = h6.REQ_ID (+) AND h4.rcv_transaction_id = h7.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 9839: , fnd_lookup_values fvl13

9835: ELSE null
9836: END source_meaning
9837: FROM xla_events_gt xet
9838: , CST_XLA_INV_HEADERS_V h1
9839: , fnd_lookup_values fvl13
9840: , fnd_lookup_values fvl37
9841: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
9842: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
9843: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 9840: , fnd_lookup_values fvl37

9836: END source_meaning
9837: FROM xla_events_gt xet
9838: , CST_XLA_INV_HEADERS_V h1
9839: , fnd_lookup_values fvl13
9840: , fnd_lookup_values fvl37
9841: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
9842: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
9843: AND xet.event_class_code = C_EVENT_CLASS_CODE
9844: AND h1.event_id = xet.event_id

Line 10121: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

10117: l_balance_type_code VARCHAR2(1) :=NULL;
10118: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
10119:
10120: --
10121: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
10122: --
10123:
10124: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
10125: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 10187: , fnd_lookup_values fvl13

10183: , h1.TRANSFER_TO_GL_INDICATOR source_37
10184: , fvl37.meaning source_37_meaning
10185: FROM xla_events_gt xet
10186: , CST_XLA_INV_HEADERS_V h1
10187: , fnd_lookup_values fvl13
10188: , fnd_lookup_values fvl37
10189: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
10190: and xet.event_class_code = C_EVENT_CLASS_CODE
10191: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 10188: , fnd_lookup_values fvl37

10184: , fvl37.meaning source_37_meaning
10185: FROM xla_events_gt xet
10186: , CST_XLA_INV_HEADERS_V h1
10187: , fnd_lookup_values fvl13
10188: , fnd_lookup_values fvl37
10189: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
10190: and xet.event_class_code = C_EVENT_CLASS_CODE
10191: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
10192: AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 11017: , fnd_lookup_values fvl13

11013: ELSE null
11014: END source_meaning
11015: FROM xla_events_gt xet
11016: , CST_XLA_INV_HEADERS_V h1
11017: , fnd_lookup_values fvl13
11018: , fnd_lookup_values fvl37
11019: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
11020: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
11021: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 11018: , fnd_lookup_values fvl37

11014: END source_meaning
11015: FROM xla_events_gt xet
11016: , CST_XLA_INV_HEADERS_V h1
11017: , fnd_lookup_values fvl13
11018: , fnd_lookup_values fvl37
11019: ,(select rownum r from all_objects where rownum <= 2 and owner = p_apps_owner)
11020: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
11021: AND xet.event_class_code = C_EVENT_CLASS_CODE
11022: AND h1.event_id = xet.event_id

Line 11299: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

11295: l_balance_type_code VARCHAR2(1) :=NULL;
11296: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
11297:
11298: --
11299: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
11300: --
11301:
11302: TYPE t_array_source_13 IS TABLE OF CST_XLA_INV_HEADERS_V.DISTRIBUTION_TYPE%TYPE INDEX BY BINARY_INTEGER;
11303: TYPE t_array_source_37 IS TABLE OF CST_XLA_INV_HEADERS_V.TRANSFER_TO_GL_INDICATOR%TYPE INDEX BY BINARY_INTEGER;

Line 11365: , fnd_lookup_values fvl13

11361: , h1.TRANSFER_TO_GL_INDICATOR source_37
11362: , fvl37.meaning source_37_meaning
11363: FROM xla_events_gt xet
11364: , CST_XLA_INV_HEADERS_V h1
11365: , fnd_lookup_values fvl13
11366: , fnd_lookup_values fvl37
11367: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
11368: and xet.event_class_code = C_EVENT_CLASS_CODE
11369: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 11366: , fnd_lookup_values fvl37

11362: , fvl37.meaning source_37_meaning
11363: FROM xla_events_gt xet
11364: , CST_XLA_INV_HEADERS_V h1
11365: , fnd_lookup_values fvl13
11366: , fnd_lookup_values fvl37
11367: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
11368: and xet.event_class_code = C_EVENT_CLASS_CODE
11369: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
11370: AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 12259: , fnd_lookup_values fvl13

12255: , CST_XLA_RCV_REF_V h3
12256: , PO_DISTS_REF_V h4
12257: , PO_HEADERS_REF_V h5
12258: , PSA_CST_XLA_PEA_UPG_V h6
12259: , fnd_lookup_values fvl13
12260: , fnd_lookup_values fvl37
12261: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
12262: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
12263: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 12260: , fnd_lookup_values fvl37

12256: , PO_DISTS_REF_V h4
12257: , PO_HEADERS_REF_V h5
12258: , PSA_CST_XLA_PEA_UPG_V h6
12259: , fnd_lookup_values fvl13
12260: , fnd_lookup_values fvl37
12261: ,(select rownum r from all_objects where rownum <= 14 and owner = p_apps_owner)
12262: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
12263: AND xet.event_class_code = C_EVENT_CLASS_CODE
12264: AND h1.event_id = xet.event_id

Line 12506: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

12502: l_balance_type_code VARCHAR2(1) :=NULL;
12503: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
12504:
12505: --
12506: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
12507: --
12508:
12509: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
12510: TYPE t_array_source_7 IS TABLE OF CST_XLA_RCV_REF_V.APPLIED_TO_APPL_ID%TYPE INDEX BY BINARY_INTEGER;

Line 12598: , fnd_lookup_values fvl13

12594: , CST_XLA_RCV_REF_V h3
12595: , PO_DISTS_REF_V h4
12596: , PO_HEADERS_REF_V h5
12597: , PSA_CST_XLA_PEA_UPG_V h6
12598: , fnd_lookup_values fvl13
12599: , fnd_lookup_values fvl37
12600: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
12601: and xet.event_class_code = C_EVENT_CLASS_CODE
12602: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 12599: , fnd_lookup_values fvl37

12595: , PO_DISTS_REF_V h4
12596: , PO_HEADERS_REF_V h5
12597: , PSA_CST_XLA_PEA_UPG_V h6
12598: , fnd_lookup_values fvl13
12599: , fnd_lookup_values fvl37
12600: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
12601: and xet.event_class_code = C_EVENT_CLASS_CODE
12602: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
12603: AND h3.REF_RCV_ACCOUNTING_EVENT_ID = h1.RCV_ACCOUNTING_EVENT_ID AND h3.po_header_id = h4.po_header_id (+) AND h3.po_distribution_id = h4.po_distribution_id (+) AND h3.po_header_id = h5.po_header_id (+) AND h3.ref_rcv_accounting_event_id = h6.accounting_event_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'

Line 13561: , fnd_lookup_values fvl13

13557: , CST_XLA_INV_REF_V h4
13558: , PO_DISTS_REF_V h5
13559: , PO_HEADERS_REF_V h6
13560: , PSA_CST_XLA_UPG_V h7
13561: , fnd_lookup_values fvl13
13562: , fnd_lookup_values fvl37
13563: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
13564: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
13565: AND xet.event_class_code = C_EVENT_CLASS_CODE

Line 13562: , fnd_lookup_values fvl37

13558: , PO_DISTS_REF_V h5
13559: , PO_HEADERS_REF_V h6
13560: , PSA_CST_XLA_UPG_V h7
13561: , fnd_lookup_values fvl13
13562: , fnd_lookup_values fvl37
13563: ,(select rownum r from all_objects where rownum <= 15 and owner = p_apps_owner)
13564: WHERE xet.event_date between p_pad_start_date AND p_pad_end_date
13565: AND xet.event_class_code = C_EVENT_CLASS_CODE
13566: AND h1.event_id = xet.event_id

Line 13813: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;

13809: l_balance_type_code VARCHAR2(1) :=NULL;
13810: l_gain_or_loss_ref VARCHAR2(30) :=NULL;
13811:
13812: --
13813: TYPE t_array_lookup_meaning IS TABLE OF fnd_lookup_values.meaning%TYPE INDEX BY BINARY_INTEGER;
13814: --
13815:
13816: TYPE t_array_source_2 IS TABLE OF PO_HEADERS_REF_V.PURCH_ENCUMBRANCE_FLAG%TYPE INDEX BY BINARY_INTEGER;
13817: TYPE t_array_source_3 IS TABLE OF PO_DISTS_REF_V.RESERVED_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 13911: , fnd_lookup_values fvl13

13907: , CST_XLA_INV_REF_V h4
13908: , PO_DISTS_REF_V h5
13909: , PO_HEADERS_REF_V h6
13910: , PSA_CST_XLA_UPG_V h7
13911: , fnd_lookup_values fvl13
13912: , fnd_lookup_values fvl37
13913: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
13914: and xet.event_class_code = C_EVENT_CLASS_CODE
13915: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id

Line 13912: , fnd_lookup_values fvl37

13908: , PO_DISTS_REF_V h5
13909: , PO_HEADERS_REF_V h6
13910: , PSA_CST_XLA_UPG_V h7
13911: , fnd_lookup_values fvl13
13912: , fnd_lookup_values fvl37
13913: WHERE xet.event_date between p_pad_start_date and p_pad_end_date
13914: and xet.event_class_code = C_EVENT_CLASS_CODE
13915: and xet.event_status_code <> 'N' AND h1.event_id = xet.event_id
13916: AND h3.INV_ORGANIZATION_ID (+) = h1.ORGANIZATION_ID AND h4.ref_transaction_id = h1.transaction_id AND h4.txn_po_header_id = h5.po_header_id (+) AND h4.txn_po_distribution_id = h5.po_distribution_id (+) AND h4.txn_po_header_id = h6.po_header_id (+) AND h4.rcv_transaction_id = h7.transaction_id (+) AND fvl13.lookup_type(+) = 'CST_DISTRIBUTION_TYPE'