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.AMW_FINSTMT_CERT_PVT dependencies on AMW_FIN_STMNT_ITEMS_B

Line 3557: AMW_FIN_STMNT_ITEMS_B

3553: STATEMENT_GROUP_ID,
3554: FINANCIAL_STATEMENT_ID,
3555: FINANCIAL_ITEM_ID
3556: from
3557: AMW_FIN_STMNT_ITEMS_B
3558: where
3559: STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
3560: and FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
3561: and PARENT_FINANCIAL_ITEM_ID is null;

Line 3574: AMW_FIN_STMNT_ITEMS_B

3570: FINANCIAL_STATEMENT_ID,
3571: FINANCIAL_ITEM_ID,
3572: PARENT_FINANCIAL_ITEM_ID
3573: from
3574: AMW_FIN_STMNT_ITEMS_B
3575: where
3576: STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
3577: and FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
3578: and PARENT_FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID ;

Line 5955: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

5951: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
5952: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
5953: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
5954: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
5955: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
5956: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
5957: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
5958: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
5959: -- )

Line 5986: from amw_fin_stmnt_items_b item

5982: and item.statement_group_id = p_statement_group_id
5983: and item.financial_statement_id = p_financial_statement_id
5984: union
5985: select distinct item.financial_item_id
5986: from amw_fin_stmnt_items_b item
5987: where item.financial_item_id = p_financial_item_id
5988: and item.statement_group_id = p_statement_group_id
5989: and item.financial_statement_id = p_financial_statement_id
5990: )

Line 6008: from amw_fin_stmnt_items_b item

6004: and item.statement_group_id = p_statement_group_id
6005: and item.financial_statement_id = p_financial_statement_id
6006: union
6007: select distinct item.financial_item_id
6008: from amw_fin_stmnt_items_b item
6009: where item.financial_item_id = p_financial_item_id
6010: and item.statement_group_id = p_statement_group_id
6011: and item.financial_statement_id = p_financial_statement_id
6012: )

Line 6074: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

6070: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6071: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6072: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
6073: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
6074: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
6075: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
6076: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6077: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6078: -- )

Line 6105: from amw_fin_stmnt_items_b item

6101: and item.statement_group_id = p_statement_group_id
6102: and item.financial_statement_id = p_financial_statement_id
6103: union
6104: select distinct item.financial_item_id
6105: from amw_fin_stmnt_items_b item
6106: where item.financial_item_id = p_financial_item_id
6107: and item.statement_group_id = p_statement_group_id
6108: and item.financial_statement_id = p_financial_statement_id
6109: )

Line 6127: from amw_fin_stmnt_items_b item

6123: and item.statement_group_id = p_statement_group_id
6124: and item.financial_statement_id = p_financial_statement_id
6125: union
6126: select distinct item.financial_item_id
6127: from amw_fin_stmnt_items_b item
6128: where item.financial_item_id = p_financial_item_id
6129: and item.statement_group_id = p_statement_group_id
6130: and item.financial_statement_id = p_financial_statement_id
6131: )

Line 6210: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

6206: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6207: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6208: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
6209: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
6210: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
6211: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
6212: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6213: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6214: -- )

Line 6241: from amw_fin_stmnt_items_b item

6237: and item.statement_group_id = p_statement_group_id
6238: and item.financial_statement_id = p_financial_statement_id
6239: union
6240: select distinct item.financial_item_id
6241: from amw_fin_stmnt_items_b item
6242: where item.financial_item_id = p_financial_item_id
6243: and item.statement_group_id = p_statement_group_id
6244: and item.financial_statement_id = p_financial_statement_id
6245: )

Line 6263: from amw_fin_stmnt_items_b item

6259: and item.statement_group_id = p_statement_group_id
6260: and item.financial_statement_id = p_financial_statement_id
6261: union
6262: select distinct item.financial_item_id
6263: from amw_fin_stmnt_items_b item
6264: where item.financial_item_id = p_financial_item_id
6265: and item.statement_group_id = p_statement_group_id
6266: and item.financial_statement_id = p_financial_statement_id
6267: )

Line 6343: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

6339: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6340: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6341: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
6342: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
6343: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
6344: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
6345: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6346: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6347: -- )

Line 6374: from amw_fin_stmnt_items_b item

6370: and item.statement_group_id = p_statement_group_id
6371: and item.financial_statement_id = p_financial_statement_id
6372: union
6373: select distinct item.financial_item_id
6374: from amw_fin_stmnt_items_b item
6375: where item.financial_item_id = p_financial_item_id
6376: and item.statement_group_id = p_statement_group_id
6377: and item.financial_statement_id = p_financial_statement_id
6378: )

Line 6396: from amw_fin_stmnt_items_b item

6392: and item.statement_group_id = p_statement_group_id
6393: and item.financial_statement_id = p_financial_statement_id
6394: union
6395: select distinct item.financial_item_id
6396: from amw_fin_stmnt_items_b item
6397: where item.financial_item_id = p_financial_item_id
6398: and item.statement_group_id = p_statement_group_id
6399: and item.financial_statement_id = p_financial_statement_id
6400: )

Line 6477: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

6473: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6474: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6475: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
6476: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
6477: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
6478: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
6479: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6480: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6481: -- )

Line 6508: from amw_fin_stmnt_items_b item

6504: and item.statement_group_id = p_statement_group_id
6505: and item.financial_statement_id = p_financial_statement_id
6506: union
6507: select distinct item.financial_item_id
6508: from amw_fin_stmnt_items_b item
6509: where item.financial_item_id = p_financial_item_id
6510: and item.statement_group_id = p_statement_group_id
6511: and item.financial_statement_id = p_financial_statement_id
6512: )

Line 6530: from amw_fin_stmnt_items_b item

6526: and item.statement_group_id = p_statement_group_id
6527: and item.financial_statement_id = p_financial_statement_id
6528: union
6529: select distinct item.financial_item_id
6530: from amw_fin_stmnt_items_b item
6531: where item.financial_item_id = p_financial_item_id
6532: and item.statement_group_id = p_statement_group_id
6533: and item.financial_statement_id = p_financial_statement_id
6534: )

Line 6582: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

6578: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6579: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6580: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
6581: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
6582: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
6583: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
6584: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6585: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6586: -- )

Line 6613: from amw_fin_stmnt_items_b item

6609: and item.statement_group_id = p_statement_group_id
6610: and item.financial_statement_id = p_financial_statement_id
6611: union
6612: select distinct item.financial_item_id
6613: from amw_fin_stmnt_items_b item
6614: where item.financial_item_id = p_financial_item_id
6615: and item.statement_group_id = p_statement_group_id
6616: and item.financial_statement_id = p_financial_statement_id
6617: )

Line 6635: from amw_fin_stmnt_items_b item

6631: and item.statement_group_id = p_statement_group_id
6632: and item.financial_statement_id = p_financial_statement_id
6633: union
6634: select distinct item.financial_item_id
6635: from amw_fin_stmnt_items_b item
6636: where item.financial_item_id = p_financial_item_id
6637: and item.statement_group_id = p_statement_group_id
6638: and item.financial_statement_id = p_financial_statement_id
6639: )

Line 6702: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

6698: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6699: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6700: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
6701: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
6702: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
6703: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
6704: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6705: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6706: -- )

Line 6733: from amw_fin_stmnt_items_b item

6729: and item.statement_group_id = p_statement_group_id
6730: and item.financial_statement_id = p_financial_statement_id
6731: union
6732: select distinct item.financial_item_id
6733: from amw_fin_stmnt_items_b item
6734: where item.financial_item_id = p_financial_item_id
6735: and item.statement_group_id = p_statement_group_id
6736: and item.financial_statement_id = p_financial_statement_id
6737: )

Line 6755: from amw_fin_stmnt_items_b item

6751: and item.statement_group_id = p_statement_group_id
6752: and item.financial_statement_id = p_financial_statement_id
6753: union
6754: select distinct item.financial_item_id
6755: from amw_fin_stmnt_items_b item
6756: where item.financial_item_id = p_financial_item_id
6757: and item.statement_group_id = p_statement_group_id
6758: and item.financial_statement_id = p_financial_statement_id
6759: )

Line 6832: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

6828: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6829: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6830: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
6831: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
6832: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
6833: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
6834: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6835: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6836: -- )

Line 6863: from amw_fin_stmnt_items_b item

6859: and item.statement_group_id = p_statement_group_id
6860: and item.financial_statement_id = p_financial_statement_id
6861: union
6862: select distinct item.financial_item_id
6863: from amw_fin_stmnt_items_b item
6864: where item.financial_item_id = p_financial_item_id
6865: and item.statement_group_id = p_statement_group_id
6866: and item.financial_statement_id = p_financial_statement_id
6867: )

Line 6885: from amw_fin_stmnt_items_b item

6881: and item.statement_group_id = p_statement_group_id
6882: and item.financial_statement_id = p_financial_statement_id
6883: union
6884: select distinct item.financial_item_id
6885: from amw_fin_stmnt_items_b item
6886: where item.financial_item_id = p_financial_item_id
6887: and item.statement_group_id = p_statement_group_id
6888: and item.financial_statement_id = p_financial_statement_id
6889: )

Line 6964: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

6960: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6961: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6962: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
6963: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
6964: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
6965: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
6966: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
6967: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
6968: -- )

Line 6995: from amw_fin_stmnt_items_b item

6991: and item.statement_group_id = p_statement_group_id
6992: and item.financial_statement_id = p_financial_statement_id
6993: union
6994: select distinct item.financial_item_id
6995: from amw_fin_stmnt_items_b item
6996: where item.financial_item_id = p_financial_item_id
6997: and item.statement_group_id = p_statement_group_id
6998: and item.financial_statement_id = p_financial_statement_id
6999: )

Line 7017: from amw_fin_stmnt_items_b item

7013: and item.statement_group_id = p_statement_group_id
7014: and item.financial_statement_id = p_financial_statement_id
7015: union
7016: select distinct item.financial_item_id
7017: from amw_fin_stmnt_items_b item
7018: where item.financial_item_id = p_financial_item_id
7019: and item.statement_group_id = p_statement_group_id
7020: and item.financial_statement_id = p_financial_statement_id
7021: )

Line 7112: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

7108: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
7109: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7110: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
7111: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
7112: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
7113: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
7114: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
7115: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7116: -- )

Line 7143: from amw_fin_stmnt_items_b item

7139: and item.statement_group_id = p_statement_group_id
7140: and item.financial_statement_id = p_financial_statement_id
7141: union
7142: select distinct item.financial_item_id
7143: from amw_fin_stmnt_items_b item
7144: where item.financial_item_id = p_financial_item_id
7145: and item.statement_group_id = p_statement_group_id
7146: and item.financial_statement_id = p_financial_statement_id
7147: )

Line 7165: from amw_fin_stmnt_items_b item

7161: and item.statement_group_id = p_statement_group_id
7162: and item.financial_statement_id = p_financial_statement_id
7163: union
7164: select distinct item.financial_item_id
7165: from amw_fin_stmnt_items_b item
7166: where item.financial_item_id = p_financial_item_id
7167: and item.statement_group_id = p_statement_group_id
7168: and item.financial_statement_id = p_financial_statement_id
7169: )

Line 7255: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

7251: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
7252: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7253: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
7254: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
7255: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
7256: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
7257: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
7258: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7259: -- )

Line 7286: from amw_fin_stmnt_items_b item

7282: and item.statement_group_id = p_statement_group_id
7283: and item.financial_statement_id = p_financial_statement_id
7284: union
7285: select distinct item.financial_item_id
7286: from amw_fin_stmnt_items_b item
7287: where item.financial_item_id = p_financial_item_id
7288: and item.statement_group_id = p_statement_group_id
7289: and item.financial_statement_id = p_financial_statement_id
7290: )

Line 7308: from amw_fin_stmnt_items_b item

7304: and item.statement_group_id = p_statement_group_id
7305: and item.financial_statement_id = p_financial_statement_id
7306: union
7307: select distinct item.financial_item_id
7308: from amw_fin_stmnt_items_b item
7309: where item.financial_item_id = p_financial_item_id
7310: and item.statement_group_id = p_statement_group_id
7311: and item.financial_statement_id = p_financial_statement_id
7312: )

Line 7365: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

7361: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
7362: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7363: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
7364: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
7365: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
7366: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
7367: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
7368: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7369: -- )

Line 7396: from amw_fin_stmnt_items_b item

7392: and item.statement_group_id = p_statement_group_id
7393: and item.financial_statement_id = p_financial_statement_id
7394: union
7395: select distinct item.financial_item_id
7396: from amw_fin_stmnt_items_b item
7397: where item.financial_item_id = p_financial_item_id
7398: and item.statement_group_id = p_statement_group_id
7399: and item.financial_statement_id = p_financial_statement_id
7400: )

Line 7418: from amw_fin_stmnt_items_b item

7414: and item.statement_group_id = p_statement_group_id
7415: and item.financial_statement_id = p_financial_statement_id
7416: union
7417: select distinct item.financial_item_id
7418: from amw_fin_stmnt_items_b item
7419: where item.financial_item_id = p_financial_item_id
7420: and item.statement_group_id = p_statement_group_id
7421: and item.financial_statement_id = p_financial_statement_id
7422: )

Line 7492: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

7488: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
7489: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7490: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
7491: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
7492: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
7493: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
7494: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
7495: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7496: -- )

Line 7523: from amw_fin_stmnt_items_b item

7519: and item.statement_group_id = p_statement_group_id
7520: and item.financial_statement_id = p_financial_statement_id
7521: union
7522: select distinct item.financial_item_id
7523: from amw_fin_stmnt_items_b item
7524: where item.financial_item_id = p_financial_item_id
7525: and item.statement_group_id = p_statement_group_id
7526: and item.financial_statement_id = p_financial_statement_id
7527: )

Line 7545: from amw_fin_stmnt_items_b item

7541: and item.statement_group_id = p_statement_group_id
7542: and item.financial_statement_id = p_financial_statement_id
7543: union
7544: select distinct item.financial_item_id
7545: from amw_fin_stmnt_items_b item
7546: where item.financial_item_id = p_financial_item_id
7547: and item.statement_group_id = p_statement_group_id
7548: and item.financial_statement_id = p_financial_statement_id
7549: )

Line 7609: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

7605: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
7606: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7607: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
7608: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
7609: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
7610: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
7611: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
7612: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7613: -- )

Line 7640: from amw_fin_stmnt_items_b item

7636: and item.statement_group_id = p_statement_group_id
7637: and item.financial_statement_id = p_financial_statement_id
7638: union
7639: select distinct item.financial_item_id
7640: from amw_fin_stmnt_items_b item
7641: where item.financial_item_id = p_financial_item_id
7642: and item.statement_group_id = p_statement_group_id
7643: and item.financial_statement_id = p_financial_statement_id
7644: )

Line 7662: from amw_fin_stmnt_items_b item

7658: and item.statement_group_id = p_statement_group_id
7659: and item.financial_statement_id = p_financial_statement_id
7660: union
7661: select distinct item.financial_item_id
7662: from amw_fin_stmnt_items_b item
7663: where item.financial_item_id = p_financial_item_id
7664: and item.statement_group_id = p_statement_group_id
7665: and item.financial_statement_id = p_financial_statement_id
7666: )

Line 7739: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

7735: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
7736: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7737: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
7738: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
7739: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
7740: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
7741: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
7742: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7743: -- )

Line 7770: from amw_fin_stmnt_items_b item

7766: and item.statement_group_id = p_statement_group_id
7767: and item.financial_statement_id = p_financial_statement_id
7768: union
7769: select distinct item.financial_item_id
7770: from amw_fin_stmnt_items_b item
7771: where item.financial_item_id = p_financial_item_id
7772: and item.statement_group_id = p_statement_group_id
7773: and item.financial_statement_id = p_financial_statement_id
7774: )

Line 7792: from amw_fin_stmnt_items_b item

7788: and item.statement_group_id = p_statement_group_id
7789: and item.financial_statement_id = p_financial_statement_id
7790: union
7791: select distinct item.financial_item_id
7792: from amw_fin_stmnt_items_b item
7793: where item.financial_item_id = p_financial_item_id
7794: and item.statement_group_id = p_statement_group_id
7795: and item.financial_statement_id = p_financial_statement_id
7796: )

Line 7866: -- from AMW_FIN_STMNT_ITEMS_B stmtitem

7862: -- finkeyacc.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
7863: -- and finkeyacc.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7864: -- and finkeyacc.FINANCIAL_ITEM_ID IN (select
7865: -- distinct(stmtitem.FINANCIAL_ITEM_ID )
7866: -- from AMW_FIN_STMNT_ITEMS_B stmtitem
7867: -- START WITH (stmtitem.FINANCIAL_ITEM_ID = P_FINANCIAL_ITEM_ID
7868: -- and stmtitem.STATEMENT_GROUP_ID = P_STATEMENT_GROUP_ID
7869: -- and stmtitem.FINANCIAL_STATEMENT_ID = P_FINANCIAL_STATEMENT_ID
7870: -- )

Line 7897: from amw_fin_stmnt_items_b item

7893: and item.statement_group_id = p_statement_group_id
7894: and item.financial_statement_id = p_financial_statement_id
7895: union
7896: select distinct item.financial_item_id
7897: from amw_fin_stmnt_items_b item
7898: where item.financial_item_id = p_financial_item_id
7899: and item.statement_group_id = p_statement_group_id
7900: and item.financial_statement_id = p_financial_statement_id
7901: )

Line 7919: from amw_fin_stmnt_items_b item

7915: and item.statement_group_id = p_statement_group_id
7916: and item.financial_statement_id = p_financial_statement_id
7917: union
7918: select distinct item.financial_item_id
7919: from amw_fin_stmnt_items_b item
7920: where item.financial_item_id = p_financial_item_id
7921: and item.statement_group_id = p_statement_group_id
7922: and item.financial_statement_id = p_financial_statement_id
7923: )