APPS.AMW_FINSTMT_CERT_PVT dependencies on AMW_FIN_ITEM_FLAT

Line 5980: from amw_fin_item_flat item

5976: where finkeyacc.statement_group_id = p_statement_group_id
5977: and finkeyacc.financial_statement_id = p_financial_statement_id
5978: and finkeyacc.financial_item_id in
5979: ( select distinct item.child_financial_item_id
5980: from amw_fin_item_flat item
5981: where item.parent_financial_item_id = p_financial_item_id
5982: and item.statement_group_id = p_statement_group_id
5983: and item.financial_statement_id = p_financial_statement_id
5984: union

Line 6002: from amw_fin_item_flat item

5998: where finkeyacc.statement_group_id = p_statement_group_id
5999: and finkeyacc.financial_statement_id = p_financial_statement_id
6000: and finkeyacc.financial_item_id in
6001: ( select distinct item.child_financial_item_id
6002: from amw_fin_item_flat item
6003: where item.parent_financial_item_id = p_financial_item_id
6004: and item.statement_group_id = p_statement_group_id
6005: and item.financial_statement_id = p_financial_statement_id
6006: union

Line 6099: from amw_fin_item_flat item

6095: where finkeyacc.statement_group_id = p_statement_group_id
6096: and finkeyacc.financial_statement_id = p_financial_statement_id
6097: and finkeyacc.financial_item_id in
6098: ( select distinct item.child_financial_item_id
6099: from amw_fin_item_flat item
6100: where item.parent_financial_item_id = p_financial_item_id
6101: and item.statement_group_id = p_statement_group_id
6102: and item.financial_statement_id = p_financial_statement_id
6103: union

Line 6121: from amw_fin_item_flat item

6117: where finkeyacc.statement_group_id = p_statement_group_id
6118: and finkeyacc.financial_statement_id = p_financial_statement_id
6119: and finkeyacc.financial_item_id in
6120: ( select distinct item.child_financial_item_id
6121: from amw_fin_item_flat item
6122: where item.parent_financial_item_id = p_financial_item_id
6123: and item.statement_group_id = p_statement_group_id
6124: and item.financial_statement_id = p_financial_statement_id
6125: union

Line 6235: from amw_fin_item_flat item

6231: where finkeyacc.statement_group_id = p_statement_group_id
6232: and finkeyacc.financial_statement_id = p_financial_statement_id
6233: and finkeyacc.financial_item_id in
6234: ( select distinct item.child_financial_item_id
6235: from amw_fin_item_flat item
6236: where item.parent_financial_item_id = p_financial_item_id
6237: and item.statement_group_id = p_statement_group_id
6238: and item.financial_statement_id = p_financial_statement_id
6239: union

Line 6257: from amw_fin_item_flat item

6253: where finkeyacc.statement_group_id = p_statement_group_id
6254: and finkeyacc.financial_statement_id = p_financial_statement_id
6255: and finkeyacc.financial_item_id in
6256: ( select distinct item.child_financial_item_id
6257: from amw_fin_item_flat item
6258: where item.parent_financial_item_id = p_financial_item_id
6259: and item.statement_group_id = p_statement_group_id
6260: and item.financial_statement_id = p_financial_statement_id
6261: union

Line 6368: from amw_fin_item_flat item

6364: where finkeyacc.statement_group_id = p_statement_group_id
6365: and finkeyacc.financial_statement_id = p_financial_statement_id
6366: and finkeyacc.financial_item_id in
6367: ( select distinct item.child_financial_item_id
6368: from amw_fin_item_flat item
6369: where item.parent_financial_item_id = p_financial_item_id
6370: and item.statement_group_id = p_statement_group_id
6371: and item.financial_statement_id = p_financial_statement_id
6372: union

Line 6390: from amw_fin_item_flat item

6386: where finkeyacc.statement_group_id = p_statement_group_id
6387: and finkeyacc.financial_statement_id = p_financial_statement_id
6388: and finkeyacc.financial_item_id in
6389: ( select distinct item.child_financial_item_id
6390: from amw_fin_item_flat item
6391: where item.parent_financial_item_id = p_financial_item_id
6392: and item.statement_group_id = p_statement_group_id
6393: and item.financial_statement_id = p_financial_statement_id
6394: union

Line 6502: from amw_fin_item_flat item

6498: where finkeyacc.statement_group_id = p_statement_group_id
6499: and finkeyacc.financial_statement_id = p_financial_statement_id
6500: and finkeyacc.financial_item_id in
6501: ( select distinct item.child_financial_item_id
6502: from amw_fin_item_flat item
6503: where item.parent_financial_item_id = p_financial_item_id
6504: and item.statement_group_id = p_statement_group_id
6505: and item.financial_statement_id = p_financial_statement_id
6506: union

Line 6524: from amw_fin_item_flat item

6520: where finkeyacc.statement_group_id = p_statement_group_id
6521: and finkeyacc.financial_statement_id = p_financial_statement_id
6522: and finkeyacc.financial_item_id in
6523: ( select distinct item.child_financial_item_id
6524: from amw_fin_item_flat item
6525: where item.parent_financial_item_id = p_financial_item_id
6526: and item.statement_group_id = p_statement_group_id
6527: and item.financial_statement_id = p_financial_statement_id
6528: union

Line 6607: from amw_fin_item_flat item

6603: where finkeyacc.statement_group_id = p_statement_group_id
6604: and finkeyacc.financial_statement_id = p_financial_statement_id
6605: and finkeyacc.financial_item_id in
6606: ( select distinct item.child_financial_item_id
6607: from amw_fin_item_flat item
6608: where item.parent_financial_item_id = p_financial_item_id
6609: and item.statement_group_id = p_statement_group_id
6610: and item.financial_statement_id = p_financial_statement_id
6611: union

Line 6629: from amw_fin_item_flat item

6625: where finkeyacc.statement_group_id = p_statement_group_id
6626: and finkeyacc.financial_statement_id = p_financial_statement_id
6627: and finkeyacc.financial_item_id in
6628: ( select distinct item.child_financial_item_id
6629: from amw_fin_item_flat item
6630: where item.parent_financial_item_id = p_financial_item_id
6631: and item.statement_group_id = p_statement_group_id
6632: and item.financial_statement_id = p_financial_statement_id
6633: union

Line 6727: from amw_fin_item_flat item

6723: where finkeyacc.statement_group_id = p_statement_group_id
6724: and finkeyacc.financial_statement_id = p_financial_statement_id
6725: and finkeyacc.financial_item_id in
6726: ( select distinct item.child_financial_item_id
6727: from amw_fin_item_flat item
6728: where item.parent_financial_item_id = p_financial_item_id
6729: and item.statement_group_id = p_statement_group_id
6730: and item.financial_statement_id = p_financial_statement_id
6731: union

Line 6749: from amw_fin_item_flat item

6745: where finkeyacc.statement_group_id = p_statement_group_id
6746: and finkeyacc.financial_statement_id = p_financial_statement_id
6747: and finkeyacc.financial_item_id in
6748: ( select distinct item.child_financial_item_id
6749: from amw_fin_item_flat item
6750: where item.parent_financial_item_id = p_financial_item_id
6751: and item.statement_group_id = p_statement_group_id
6752: and item.financial_statement_id = p_financial_statement_id
6753: union

Line 6857: from amw_fin_item_flat item

6853: where finkeyacc.statement_group_id = p_statement_group_id
6854: and finkeyacc.financial_statement_id = p_financial_statement_id
6855: and finkeyacc.financial_item_id in
6856: ( select distinct item.child_financial_item_id
6857: from amw_fin_item_flat item
6858: where item.parent_financial_item_id = p_financial_item_id
6859: and item.statement_group_id = p_statement_group_id
6860: and item.financial_statement_id = p_financial_statement_id
6861: union

Line 6879: from amw_fin_item_flat item

6875: where finkeyacc.statement_group_id = p_statement_group_id
6876: and finkeyacc.financial_statement_id = p_financial_statement_id
6877: and finkeyacc.financial_item_id in
6878: ( select distinct item.child_financial_item_id
6879: from amw_fin_item_flat item
6880: where item.parent_financial_item_id = p_financial_item_id
6881: and item.statement_group_id = p_statement_group_id
6882: and item.financial_statement_id = p_financial_statement_id
6883: union

Line 6989: from amw_fin_item_flat item

6985: where finkeyacc.statement_group_id = p_statement_group_id
6986: and finkeyacc.financial_statement_id = p_financial_statement_id
6987: and finkeyacc.financial_item_id in
6988: ( select distinct item.child_financial_item_id
6989: from amw_fin_item_flat item
6990: where item.parent_financial_item_id = p_financial_item_id
6991: and item.statement_group_id = p_statement_group_id
6992: and item.financial_statement_id = p_financial_statement_id
6993: union

Line 7011: from amw_fin_item_flat item

7007: where finkeyacc.statement_group_id = p_statement_group_id
7008: and finkeyacc.financial_statement_id = p_financial_statement_id
7009: and finkeyacc.financial_item_id in
7010: ( select distinct item.child_financial_item_id
7011: from amw_fin_item_flat item
7012: where item.parent_financial_item_id = p_financial_item_id
7013: and item.statement_group_id = p_statement_group_id
7014: and item.financial_statement_id = p_financial_statement_id
7015: union

Line 7137: from amw_fin_item_flat item

7133: where finkeyacc.statement_group_id = p_statement_group_id
7134: and finkeyacc.financial_statement_id = p_financial_statement_id
7135: and finkeyacc.financial_item_id in
7136: ( select distinct item.child_financial_item_id
7137: from amw_fin_item_flat item
7138: where item.parent_financial_item_id = p_financial_item_id
7139: and item.statement_group_id = p_statement_group_id
7140: and item.financial_statement_id = p_financial_statement_id
7141: union

Line 7159: from amw_fin_item_flat item

7155: where finkeyacc.statement_group_id = p_statement_group_id
7156: and finkeyacc.financial_statement_id = p_financial_statement_id
7157: and finkeyacc.financial_item_id in
7158: ( select distinct item.child_financial_item_id
7159: from amw_fin_item_flat item
7160: where item.parent_financial_item_id = p_financial_item_id
7161: and item.statement_group_id = p_statement_group_id
7162: and item.financial_statement_id = p_financial_statement_id
7163: union

Line 7280: from amw_fin_item_flat item

7276: where finkeyacc.statement_group_id = p_statement_group_id
7277: and finkeyacc.financial_statement_id = p_financial_statement_id
7278: and finkeyacc.financial_item_id in
7279: ( select distinct item.child_financial_item_id
7280: from amw_fin_item_flat item
7281: where item.parent_financial_item_id = p_financial_item_id
7282: and item.statement_group_id = p_statement_group_id
7283: and item.financial_statement_id = p_financial_statement_id
7284: union

Line 7302: from amw_fin_item_flat item

7298: where finkeyacc.statement_group_id = p_statement_group_id
7299: and finkeyacc.financial_statement_id = p_financial_statement_id
7300: and finkeyacc.financial_item_id in
7301: ( select distinct item.child_financial_item_id
7302: from amw_fin_item_flat item
7303: where item.parent_financial_item_id = p_financial_item_id
7304: and item.statement_group_id = p_statement_group_id
7305: and item.financial_statement_id = p_financial_statement_id
7306: union

Line 7390: from amw_fin_item_flat item

7386: where finkeyacc.statement_group_id = p_statement_group_id
7387: and finkeyacc.financial_statement_id = p_financial_statement_id
7388: and finkeyacc.financial_item_id in
7389: ( select distinct item.child_financial_item_id
7390: from amw_fin_item_flat item
7391: where item.parent_financial_item_id = p_financial_item_id
7392: and item.statement_group_id = p_statement_group_id
7393: and item.financial_statement_id = p_financial_statement_id
7394: union

Line 7412: from amw_fin_item_flat item

7408: where finkeyacc.statement_group_id = p_statement_group_id
7409: and finkeyacc.financial_statement_id = p_financial_statement_id
7410: and finkeyacc.financial_item_id in
7411: ( select distinct item.child_financial_item_id
7412: from amw_fin_item_flat item
7413: where item.parent_financial_item_id = p_financial_item_id
7414: and item.statement_group_id = p_statement_group_id
7415: and item.financial_statement_id = p_financial_statement_id
7416: union

Line 7517: from amw_fin_item_flat item

7513: where finkeyacc.statement_group_id = p_statement_group_id
7514: and finkeyacc.financial_statement_id = p_financial_statement_id
7515: and finkeyacc.financial_item_id in
7516: ( select distinct item.child_financial_item_id
7517: from amw_fin_item_flat item
7518: where item.parent_financial_item_id = p_financial_item_id
7519: and item.statement_group_id = p_statement_group_id
7520: and item.financial_statement_id = p_financial_statement_id
7521: union

Line 7539: from amw_fin_item_flat item

7535: where finkeyacc.statement_group_id = p_statement_group_id
7536: and finkeyacc.financial_statement_id = p_financial_statement_id
7537: and finkeyacc.financial_item_id in
7538: ( select distinct item.child_financial_item_id
7539: from amw_fin_item_flat item
7540: where item.parent_financial_item_id = p_financial_item_id
7541: and item.statement_group_id = p_statement_group_id
7542: and item.financial_statement_id = p_financial_statement_id
7543: union

Line 7634: from amw_fin_item_flat item

7630: where finkeyacc.statement_group_id = p_statement_group_id
7631: and finkeyacc.financial_statement_id = p_financial_statement_id
7632: and finkeyacc.financial_item_id in
7633: ( select distinct item.child_financial_item_id
7634: from amw_fin_item_flat item
7635: where item.parent_financial_item_id = p_financial_item_id
7636: and item.statement_group_id = p_statement_group_id
7637: and item.financial_statement_id = p_financial_statement_id
7638: union

Line 7656: from amw_fin_item_flat item

7652: where finkeyacc.statement_group_id = p_statement_group_id
7653: and finkeyacc.financial_statement_id = p_financial_statement_id
7654: and finkeyacc.financial_item_id in
7655: ( select distinct item.child_financial_item_id
7656: from amw_fin_item_flat item
7657: where item.parent_financial_item_id = p_financial_item_id
7658: and item.statement_group_id = p_statement_group_id
7659: and item.financial_statement_id = p_financial_statement_id
7660: union

Line 7764: from amw_fin_item_flat item

7760: where finkeyacc.statement_group_id = p_statement_group_id
7761: and finkeyacc.financial_statement_id = p_financial_statement_id
7762: and finkeyacc.financial_item_id in
7763: ( select distinct item.child_financial_item_id
7764: from amw_fin_item_flat item
7765: where item.parent_financial_item_id = p_financial_item_id
7766: and item.statement_group_id = p_statement_group_id
7767: and item.financial_statement_id = p_financial_statement_id
7768: union

Line 7786: from amw_fin_item_flat item

7782: where finkeyacc.statement_group_id = p_statement_group_id
7783: and finkeyacc.financial_statement_id = p_financial_statement_id
7784: and finkeyacc.financial_item_id in
7785: ( select distinct item.child_financial_item_id
7786: from amw_fin_item_flat item
7787: where item.parent_financial_item_id = p_financial_item_id
7788: and item.statement_group_id = p_statement_group_id
7789: and item.financial_statement_id = p_financial_statement_id
7790: union

Line 7891: from amw_fin_item_flat item

7887: where finkeyacc.statement_group_id = p_statement_group_id
7888: and finkeyacc.financial_statement_id = p_financial_statement_id
7889: and finkeyacc.financial_item_id in
7890: ( select distinct item.child_financial_item_id
7891: from amw_fin_item_flat item
7892: where item.parent_financial_item_id = p_financial_item_id
7893: and item.statement_group_id = p_statement_group_id
7894: and item.financial_statement_id = p_financial_statement_id
7895: union

Line 7913: from amw_fin_item_flat item

7909: where finkeyacc.statement_group_id = p_statement_group_id
7910: and finkeyacc.financial_statement_id = p_financial_statement_id
7911: and finkeyacc.financial_item_id in
7912: ( select distinct item.child_financial_item_id
7913: from amw_fin_item_flat item
7914: where item.parent_financial_item_id = p_financial_item_id
7915: and item.statement_group_id = p_statement_group_id
7916: and item.financial_statement_id = p_financial_statement_id
7917: union