DBA Data[Home] [Help]

APPS.INV_QUANTITY_TREE_PVT dependencies on MTL_TXN_REQUEST_HEADERS

Line 4451: from mtl_txn_request_headers mtrh

4447: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
4448: * to_number(NULL)) transaction_action_id */
4449: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
4450: decode ((select move_order_type
4451: from mtl_txn_request_headers mtrh
4452: where header_id = mmtt.move_order_header_id
4453: and rownum = 1),5,28,mmtt.transaction_action_id),
4454: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
4455: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 4673: from mtl_txn_request_headers mtrh

4669: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
4670: * to_number(NULL)) transaction_action_id */
4671: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
4672: decode ((select move_order_type
4673: from mtl_txn_request_headers mtrh
4674: where header_id = mmtt.move_order_header_id
4675: and rownum = 1),5,28,mmtt.transaction_action_id),
4676: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
4677: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 4965: from mtl_txn_request_headers mtrh

4961: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
4962: * to_number(NULL)) transaction_action_id */
4963: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
4964: decode ((select move_order_type
4965: from mtl_txn_request_headers mtrh
4966: where header_id = mmtt.move_order_header_id
4967: and rownum = 1),5,28,mmtt.transaction_action_id),
4968: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
4969: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 5019: from mtl_txn_request_headers mtrh

5015: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
5016: * to_number(NULL)) transaction_action_id */
5017: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
5018: decode ((select move_order_type
5019: from mtl_txn_request_headers mtrh
5020: where header_id = mmtt.move_order_header_id
5021: and rownum = 1),5,28,mmtt.transaction_action_id),
5022: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
5023: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 5366: from mtl_txn_request_headers mtrh

5362: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
5363: * to_number(NULL)) transaction_action_id */
5364: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
5365: decode ((select move_order_type
5366: from mtl_txn_request_headers mtrh
5367: where header_id = mmtt.move_order_header_id
5368: and rownum = 1),5,28,mmtt.transaction_action_id),
5369: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
5370: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 5448: from mtl_txn_request_headers mtrh

5444: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
5445: * to_number(NULL)) transaction_action_id */
5446: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
5447: decode ((select move_order_type
5448: from mtl_txn_request_headers mtrh
5449: where header_id = mmtt.move_order_header_id
5450: and rownum = 1),5,28,mmtt.transaction_action_id),
5451: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
5452: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 5835: from mtl_txn_request_headers mtrh

5831: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
5832: * to_number(NULL)) transaction_action_id */
5833: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
5834: decode ((select move_order_type
5835: from mtl_txn_request_headers mtrh
5836: where header_id = mmtt.move_order_header_id
5837: and rownum = 1),5,28,mmtt.transaction_action_id),
5838: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
5839: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 5889: from mtl_txn_request_headers mtrh

5885: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
5886: * to_number(NULL)) transaction_action_id */
5887: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
5888: decode ((select move_order_type
5889: from mtl_txn_request_headers mtrh
5890: where header_id = mmtt.move_order_header_id
5891: and rownum = 1),5,28,mmtt.transaction_action_id),
5892: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
5893: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 6154: from mtl_txn_request_headers mtrh

6150: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
6151: * to_number(NULL)) transaction_action_id */
6152: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
6153: decode ((select move_order_type
6154: from mtl_txn_request_headers mtrh
6155: where header_id = mmtt.move_order_header_id
6156: and rownum = 1),5,28,mmtt.transaction_action_id),
6157: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
6158: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 6219: from mtl_txn_request_headers mtrh

6215: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
6216: * to_number(NULL)) transaction_action_id */
6217: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
6218: decode ((select move_order_type
6219: from mtl_txn_request_headers mtrh
6220: where header_id = mmtt.move_order_header_id
6221: and rownum = 1),5,28,mmtt.transaction_action_id),
6222: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
6223: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 6605: from mtl_txn_request_headers mtrh

6601: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
6602: * to_number(NULL)) transaction_action_id */
6603: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
6604: decode ((select move_order_type
6605: from mtl_txn_request_headers mtrh
6606: where header_id = mmtt.move_order_header_id
6607: and rownum = 1),5,28,mmtt.transaction_action_id),
6608: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
6609: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 6659: from mtl_txn_request_headers mtrh

6655: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
6656: * to_number(NULL)) transaction_action_id */
6657: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
6658: decode ((select move_order_type
6659: from mtl_txn_request_headers mtrh
6660: where header_id = mmtt.move_order_header_id
6661: and rownum = 1),5,28,mmtt.transaction_action_id),
6662: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
6663: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 6924: from mtl_txn_request_headers mtrh

6920: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
6921: * to_number(NULL)) transaction_action_id */
6922: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
6923: decode ((select move_order_type
6924: from mtl_txn_request_headers mtrh
6925: where header_id = mmtt.move_order_header_id
6926: and rownum = 1),5,28,mmtt.transaction_action_id),
6927: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
6928: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 6986: from mtl_txn_request_headers mtrh

6982: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
6983: * to_number(NULL)) transaction_action_id */
6984: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
6985: decode ((select move_order_type
6986: from mtl_txn_request_headers mtrh
6987: where header_id = mmtt.move_order_header_id
6988: and rownum = 1),5,28,mmtt.transaction_action_id),
6989: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
6990: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 7387: from mtl_txn_request_headers mtrh

7383: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
7384: * to_number(NULL)) transaction_action_id */
7385: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
7386: decode ((select move_order_type
7387: from mtl_txn_request_headers mtrh
7388: where header_id = mmtt.move_order_header_id
7389: and rownum = 1),5,28,mmtt.transaction_action_id),
7390: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
7391: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 7690: from mtl_txn_request_headers mtrh

7686: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
7687: * to_number(NULL)) transaction_action_id */
7688: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
7689: decode ((select move_order_type
7690: from mtl_txn_request_headers mtrh
7691: where header_id = mmtt.move_order_header_id
7692: and rownum = 1),5,28,mmtt.transaction_action_id),
7693: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
7694: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 7772: from mtl_txn_request_headers mtrh

7768: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
7769: * to_number(NULL)) transaction_action_id */
7770: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
7771: decode ((select move_order_type
7772: from mtl_txn_request_headers mtrh
7773: where header_id = mmtt.move_order_header_id
7774: and rownum = 1),5,28,mmtt.transaction_action_id),
7775: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
7776: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 8146: from mtl_txn_request_headers mtrh

8142: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
8143: * to_number(NULL)) transaction_action_id */
8144: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
8145: decode ((select move_order_type
8146: from mtl_txn_request_headers mtrh
8147: where header_id = mmtt.move_order_header_id
8148: and rownum = 1),5,28,mmtt.transaction_action_id),
8149: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
8150: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code

Line 8228: from mtl_txn_request_headers mtrh

8224: /* Bug 9938149, Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id,
8225: * to_number(NULL)) transaction_action_id */
8226: , Decode(mmtt.transaction_status, 2 , decode (mp.process_enabled_flag, 'Y',
8227: decode ((select move_order_type
8228: from mtl_txn_request_headers mtrh
8229: where header_id = mmtt.move_order_header_id
8230: and rownum = 1),5,28,mmtt.transaction_action_id),
8231: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
8232: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code