DBA Data[Home] [Help]

APPS.ZX_SIM_TRX_DISTRIBUTION dependencies on ZX_TRANSACTION

Line 671: UPDATE ZX_TRANSACTION

667: 'Update ZX_SIM_TRX_DISTS (+)');
668: END IF;
669:
670: /*****************
671: UPDATE ZX_TRANSACTION
672: SET EVENT_TYPE_CODE = p_event_type_code
673: WHERE APPLICATION_ID = p_application_id
674: AND ENTITY_CODE = p_entity_code
675: AND EVENT_CLASS_CODE = p_event_class_code

Line 2057: FROM ZX_TRANSACTION

2053: --p_rdng_ship_to_pty_tx_p_st_id,
2054: --p_rdng_ship_fr_pty_tx_p_st_id, --reduced size p_rdng_ship_from_pty_tx_p_st_id
2055: --p_rdng_bill_to_pty_tx_p_st_id,
2056: --p_rdng_bill_fr_pty_tx_p_st_id); --reduced size p_rdng_bill_from_pty_tx_p_st_id
2057: FROM ZX_TRANSACTION
2058: WHERE APPLICATION_ID = p_application_id
2059: AND ENTITY_CODE = p_entity_code
2060: AND EVENT_CLASS_CODE = p_event_class_code
2061: AND TRX_ID = p_trx_id;

Line 2653: FROM ZX_TRANSACTION

2649: --p_rdng_ship_to_pty_tx_p_st_id,
2650: --p_rdng_ship_fr_pty_tx_p_st_id, --reduced size p_rdng_ship_from_pty_tx_p_st_id
2651: --p_rdng_bill_to_pty_tx_p_st_id,
2652: --p_rdng_bill_fr_pty_tx_p_st_id); --reduced size p_rdng_bill_from_pty_tx_p_st_id
2653: FROM ZX_TRANSACTION
2654: WHERE APPLICATION_ID = p_application_id
2655: AND ENTITY_CODE = p_entity_code
2656: AND EVENT_CLASS_CODE = p_event_class_code
2657: AND TRX_ID = p_trx_id;